Re: pg_receivelwal vs synchronous - Mailing list 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