Re: Strange decreasing value of pg_last_wal_receive_lsn()

[Sergei Kornilov]

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