| From: | Patrick B <patrickbakerbr(at)gmail(dot)com> |
|---|---|
| To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
| Cc: | John R Pierce <pierce(at)hogranch(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Streaming replication failover process - Pgsql 9.2 |
| Date: | 2016-07-11 00:39:53 |
| Message-ID: | CAJNY3itwZY+bCQcZKFF1MXTA7XX-spi1ZPg0oGy3r_uuG3wQ9w@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
2016-07-11 12:18 GMT+12:00 Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>:
> On 07/10/2016 04:28 PM, Patrick B wrote:
>
>> archive_command = 'cp %p /var/lib/pgsql/archive/%f'
>>
>
> This would be where?
>
master server
>
> And does the corresponding restore_command point to the same place?
yes.. the slaves have the restore_command pointing to the same place.
As they won't be able to communicate with master, once all the services are
up again, will have to copy them manually
>
>
>
>>
>> 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.
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2016-07-11 01:33:23 | Re: [BUGS] Where clause in pg_dump: need help |
| Previous Message | Adrian Klaver | 2016-07-11 00:18:50 | Re: Streaming replication failover process - Pgsql 9.2 |