Re: pg_receivelwal vs synchronous

From: Jesper Pedersen <jesper(dot)pedersen(at)redhat(dot)com>
To: Magnus Hagander <magnus(at)hagander(dot)net>
Cc: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: pg_receivelwal vs synchronous
Date: 2019-06-27 12:47:02
Message-ID: 5ad8cb19-de33-287c-fd0a-dd822da81e65@redhat.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Steven Lembark 2019-06-27 13:24:15 Re: migrating from Oracle to PostgreSQL 11
Previous Message Magnus Hagander 2019-06-27 12:37:39 Re: pg_receivelwal vs synchronous