From 2c8dd05d6cbc86b7ad21cfd7010e041bb4c3950b Mon Sep 17 00:00:00 2001 From: Michael Paquier Date: Sun, 17 May 2020 09:22:07 +0900 Subject: Make pg_stat_wal_receiver consistent with the WAL receiver's shmem info MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit d140f2f3 has renamed receivedUpto to flushedUpto, and has added writtenUpto to the WAL receiver's shared memory information, but pg_stat_wal_receiver was not consistent with that. This commit renames received_lsn to flushed_lsn, and adds a new column called written_lsn. Bump catalog version. Author: Michael Paquier Reviewed-by: Álvaro Herrera Discussion: https://postgr.es/m/20200515090817.GA212736@paquier.xyz --- doc/src/sgml/monitoring.sgml | 12 +++++++++++- 1 file changed, 11 insertions(+), 1 deletion(-) (limited to 'doc/src') diff --git a/doc/src/sgml/monitoring.sgml b/doc/src/sgml/monitoring.sgml index be31ac48b13..cd526128983 100644 --- a/doc/src/sgml/monitoring.sgml +++ b/doc/src/sgml/monitoring.sgml @@ -2541,7 +2541,17 @@ SELECT pid, wait_event_type, wait_event FROM pg_stat_activity WHERE wait_event i - received_lsn pg_lsn + written_lsn pg_lsn + + + Last write-ahead log location already received and written to disk, + but not flushed. This should not be used for data integrity checks. + + + + + + flushed_lsn pg_lsn Last write-ahead log location already received and flushed to -- cgit v1.2.3