Re: Trouble with replication

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: Trouble with replication
Дата
Msg-id CAB7nPqR3dumm=+6pog7SZL90ux7yQ6L38Mg3K1W-Ej9-kRBQqw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Trouble with replication  (David Greco <David_Greco@harte-hanks.com>)
Ответы Re: Trouble with replication  (David Greco <David_Greco@harte-hanks.com>)
Список pgsql-general
Дерево обсуждения



On Thu, Jun 6, 2013 at 9:19 PM, David Greco <David_Greco@harte-hanks.com> wrote:
Then what is the purpose to shipping the archived WAL files to the slave? i.e. if wal_keep_segments has to be high enough to cover any replication lag anyways, then should I even bother shipping them over?
Oh. I just noticed that you set up restore_command on slave, so if streaming replication failed due to a WAL file already removed on master, slave process will try to fetch missing WAL files from the archive.
Could you provide more logs of slave? Are you sure that the missing WAL file was not fetched from the archive after failing to get it through streaming replication?
More details at paragraph "Standby Server Operation" here:
http://www.postgresql.org/docs/9.2/static/warm-standby.html
--
Michael

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

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: PSA: If you are running Precise/12.04 upgrade your kernel.
Следующее
От: Toby Corkindale
Дата:
Сообщение: Re: PSA: If you are running Precise/12.04 upgrade your kernel.