I got it, thank you.
Can you recommend what to use to determine which quorum standby should be 
promoted in such case?
We planned to use pg_last_wal_receive_lsn() to determine which has fresh data 
but if it returns the beginning of the segment on both replicas we can’t 
determine which standby confirmed that write transaction to disk.

> On 8 May 2020, at 14:50, Sergei Kornilov <s...@zsrv.org> wrote:
> 
> Hello
> 
> Yes, this is expected. Walreceiver always start streaming from beginning of 
> the wal segment.
> ./src/backend/replication/walreceiverfuncs.c in RequestXLogStreaming:
> 
>        * We always start at the beginning of the segment. That prevents a 
> broken
>        * segment (i.e., with no records in the first half of a segment) from
>        * being created by XLOG streaming, which might cause trouble later on 
> if
>        * the segment is e.g archived.
> 
> regards, Sergei

Reply via email to