Redundant Database, Pgsql ?

[Paul Kudla (SCOM.CA Internet Services Inc.)]

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
>