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@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