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