Re: Streaming replication failover process - Pgsql 9.2

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Patrick B <patrickbakerbr(at)gmail(dot)com>, John R Pierce <pierce(at)hogranch(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Streaming replication failover process - Pgsql 9.2
Date: 2016-07-11 00:18:50
Message-ID: d8a19504-a277-f895-5d3e-0d81ab7588d4@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Patrick B 2016-07-11 00:39:53 Re: Streaming replication failover process - Pgsql 9.2
Previous Message Patrick B 2016-07-10 23:28:24 Re: Streaming replication failover process - Pgsql 9.2