Redundant Database, Pgsql ?

[Marcus Jodorf]

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