Postgres Pro
Downloads
Home   >   mailing lists

Re: Streaming replication failover process - Pgsql 9.2 - Mailing list pgsql-general

From Patrick B
Subject Re: Streaming replication failover process - Pgsql 9.2
Date
Msg-id CAJNY3ivL6j6wLYWSUgCBX=-022JmL3BbewKaEj=9SejK=FDCaA@mail.gmail.com
Whole thread Raw
In response to Re: Streaming replication failover process - Pgsql 9.2  (John R Pierce <pierce@hogranch.com>)
Responses Re: Streaming replication failover process - Pgsql 9.2
List pgsql-general
Tree view


2016-07-11 15:48 GMT+12:00 John R Pierce <pierce@hogranch.com>:
On 7/10/2016 4:28 PM, Patrick B wrote:

archive_command = 'cp %p /var/lib/pgsql/archive/%f'


That would be ok right guys?



 normally, you want to ship your WAL archives to a NFS server or something similar, which the master and all the slaves can read.

what if the network goes down?

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: Streaming replication failover process - Pgsql 9.2
Next
From: John R Pierce
Date:
Subject: Re: Streaming replication failover process - Pgsql 9.2