Home > mailing lists

Is it possible to find out write_lsn on standby? - Mailing list pgsql-hackers

From	godjan •
Subject	Is it possible to find out write_lsn on standby?
Date	May 8, 2020 16:25:02
Msg-id	F5711C73-77D3-4988-87B6-6A5C47C4384F@gmail.com Whole thread Raw
Responses	Re: Is it possible to find out write_lsn on standby? (Jehan-Guillaume de Rorthais <jgdr@dalibo.com>)
List	pgsql-hackers

Tree view

On primary I can execute ’SELECT write_lsn FROM pg_stat_replication;’ and get write_lsn of standby.
I didn’t find function like "pg_last_write_lsn()” to get write_lsn on standby. Is it possible?

pgsql-hackers by date:

From: Movead Li
Date: 08 May 2020, 15:43:50
Subject: POC and rebased patch for CSN based snapshots

From: Amit Langote
Date: 08 May 2020, 16:32:50
Subject: making update/delete of inheritance trees scale better

Is it possible to find out write_lsn on standby? - Mailing list pgsql-hackers

Previous

Next