22 Feb
2023
22 Feb
'23
1:02 p.m.
On 2/22/23 11:29, David White wrote:
If I understand open source Postgres correctly, though, this setup basically requires that the application be read-only, or at least be intelligent enough not to attempt to write to a host if it has failed over to it, right? Don't you have to have human intervention to actually fail the master / primary over for write purposes?
Yes, that is correct. But in the context of using Dovecot (passdb/userdb/quota read-only is normally sufficient).
For write fail-over you would typically use for example Pgpool-II.
Best,
Marcus