[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: pg_receivelwal vs synchronous
From:       Jesper Pedersen <jesper.pedersen () redhat ! com>
Date:       2019-06-27 12:47:02
Message-ID: 5ad8cb19-de33-287c-fd0a-dd822da81e65 () redhat ! com
[Download RAW message or body]

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


[prev in list] [next in list] [prev in thread] [next in thread]