Re: [GENERAL] wal_retrieve_retry_interval

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: [GENERAL] wal_retrieve_retry_interval
Дата
Msg-id CAB7nPqT3jzH_9Z7h=ou1Pkfzbt5+5sepCQbRZkOz29Ev6vVCLg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] wal_retrieve_retry_interval  (Ludovic Vaugeois-Pepin <ludovicvp@gmail.com>)
Ответы Re: [GENERAL] wal_retrieve_retry_interval
Список pgsql-general
On Sun, May 28, 2017 at 9:41 AM, Ludovic Vaugeois-Pepin
<ludovicvp@gmail.com> wrote:
> On Sun, May 28, 2017 at 9:49 AM, Ludovic Vaugeois-Pepin
> <ludovicvp@gmail.com> wrote:
>> It really is set at 3s on all servers (master and standbies) earlier in the "deployment" process at the same time
"listen_addresses","hot_standby", and others are set. This doesn't seem to happen every time I run tests. I increased
loggingto DEBUG1. This is what I got when the problem occurred again. Note that the empty line is there in the log
file.

Aren't those logs coming from a standby that is being reconnected to a
promoted standby? In short you restarted this standby with a fresh
recovery.conf. The WAL receiver would try to fetch history file data
for validity checks when it notices that there is a timeline jump,
when it needs to itself jump to a new timeline, and the logs you are
showing highlight that.
--
Michael


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [GENERAL] Does NUMERIC lose precision?
Следующее
От: Ludovic Vaugeois-Pepin
Дата:
Сообщение: Re: [GENERAL] wal_retrieve_retry_interval