Re: Failover replication building a new master

2018-06-06 Thread Adrian Klaver
On 06/05/2018 05:43 AM, Tom Loder wrote: I am using Postgres 10.4, and using replication, I have managed to set up four servers, with one running as a master and the other three running with streaming replication from the master. I have used the command: psql -c "ALTER SYSTEM SET synchronous_

Failover replication building a new master

2018-06-05 Thread Tom Loder
I am using Postgres 10.4, and using replication, I have managed to set up four servers, with one running as a master and the other three running with streaming replication from the master. I have used the command: psql -c "ALTER SYSTEM SET synchronous_standby_names TO 'FIRST 1(S2,S3,S4)';" so