Re: Streaming replication failover process - Pgsql 9.2

Поиск
Список
Период
Сортировка
От Patrick B
Тема Re: Streaming replication failover process - Pgsql 9.2
Дата
Msg-id CAJNY3itwZY+bCQcZKFF1MXTA7XX-spi1ZPg0oGy3r_uuG3wQ9w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Streaming replication failover process - Pgsql 9.2  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: Streaming replication failover process - Pgsql 9.2  (Patrick B <patrickbakerbr@gmail.com>)
Список pgsql-general


2016-07-11 12:18 GMT+12:00 Adrian Klaver <adrian.klaver@aklaver.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.


В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Streaming replication failover process - Pgsql 9.2
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: [BUGS] Where clause in pg_dump: need help