Paul Kudla skrev den 2023-02-19 16:01:> May I please get some guidance on what to add to talk to another > postgresql server (i have 6 replicated servers so would probably want > a couple worst case issue)change host=localhost to host=some-other-hostname-with-multiple-ips :) then dovecot with timeout and test next server ip there might be more to it, but i think this is how to do it
Paul Kudla (SCOM.CA Internet Services Inc.)
2023-Feb-21 09:02 UTC
Redundant Database, Pgsql ?
yes that seems to be the approach i setup a dns entry and pointed to 3 servers it does work round robin (ie from main, secondary etc) but that is ok at least it is working when i take the main server offline for maintenance ! Happy Tuesday !!! Thanks - paul Paul Kudla Scom.ca Internet Services <http://www.scom.ca> 004-1009 Byron Street South Whitby, Ontario - Canada L1N 4S3 Toronto 416.642.7266 Main?1.866.411.7266 Fax?1.888.892.7266 Email?paul at scom.ca On 2023-02-19 12:56 p.m., Benny Pedersen wrote:> > Paul Kudla skrev den 2023-02-19 16:01: >> May I please get some guidance on what to add to talk to another >> postgresql server (i have 6 replicated servers so would probably want >> a couple worst case issue) > > change host=localhost to host=some-other-hostname-with-multiple-ips :) > > then dovecot with timeout and test next server ip > > there might be more to it, but i think this is how to do it >