Re: pg_receivelwal vs synchronous

Поиск
Список
Период
Сортировка
От Jesper Pedersen
Тема Re: pg_receivelwal vs synchronous
Дата
Msg-id 5ad8cb19-de33-287c-fd0a-dd822da81e65@redhat.com
обсуждение исходный текст
Ответ на Re: pg_receivelwal vs synchronous  (Magnus Hagander <magnus@hagander.net>)
Список pgsql-general
Hi Magnus,

On 6/27/19 8:37 AM, Magnus Hagander wrote:
>> What am I missing here ?
>>
> 
> I believe your problem is remote_apply.
> 
> pg_receivewal never *applies* any WAL, so it just updates the write and
> flush locations. Notice how the replay_lsn remains NULL.
> 
> So you need synchronous_commit to be 'on' or 'remote_write', not
> 'remote_apply'.
> 

Yeah, remote_write works :)

I'll a patch for the pg_receivewal documentation to make this more clear.

Thanks !

Best regards,
  Jesper



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

Предыдущее
От: Magnus Hagander
Дата:
Сообщение: Re: pg_receivelwal vs synchronous
Следующее
От: Steven Lembark
Дата:
Сообщение: Re: migrating from Oracle to PostgreSQL 11