Re: Strange decreasing value of pg_last_wal_receive_lsn()

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 <sk(at)zsrv(dot)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