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

From Adrian Klaver
Subject Re: Streaming replication failover process - Pgsql 9.2
Date
Msg-id d8a19504-a277-f895-5d3e-0d81ab7588d4@aklaver.com
Whole thread Raw
In response to Re: Streaming replication failover process - Pgsql 9.2  (Patrick B <patrickbakerbr@gmail.com>)
Responses Re: Streaming replication failover process - Pgsql 9.2  (Patrick B <patrickbakerbr@gmail.com>)
List pgsql-general
On 07/10/2016 04:28 PM, Patrick B wrote:
> archive_command = 'cp %p /var/lib/pgsql/archive/%f'

This would be where?

And does the corresponding restore_command point to the same place?

>
>
> That would be ok right guys?
>
> I will also setup wal_keep_segments to 512
>

The WAL segments kept would be dependent the number of WAL segments your
database generates on average over the worse case downtime interval plus
a CYA buffer.


--
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: Patrick B
Date:
Subject: Re: Streaming replication failover process - Pgsql 9.2
Next
From: Patrick B
Date:
Subject: Re: Streaming replication failover process - Pgsql 9.2