]> granicus.if.org Git - postgresql/commit
pgstat: add WAL receiver status view & SRF
authorAlvaro Herrera <alvherre@alvh.no-ip.org>
Thu, 7 Jan 2016 19:21:19 +0000 (16:21 -0300)
committerAlvaro Herrera <alvherre@alvh.no-ip.org>
Thu, 7 Jan 2016 19:21:19 +0000 (16:21 -0300)
commitb1a9bad9e744857291c7d5516080527da8219854
treec93c41509990055a20dc91775dadba3c1e6c995a
parent6b1a837f69d00d265bee4b57ba2d320f1463f131
pgstat: add WAL receiver status view & SRF

This new view provides insight into the state of a running WAL receiver
in a HOT standby node.
The information returned includes the PID of the WAL receiver process,
its status (stopped, starting, streaming, etc), start LSN and TLI, last
received LSN and TLI, timestamp of last message send and receipt, latest
end-of-WAL LSN and time, and the name of the slot (if any).

Access to the detailed data is only granted to superusers; others only
get the PID.

Author: Michael Paquier
Reviewer: Haribabu Kommi
doc/src/sgml/monitoring.sgml
src/backend/catalog/system_views.sql
src/backend/replication/walreceiver.c
src/include/catalog/catversion.h
src/include/catalog/pg_proc.h
src/include/replication/walreceiver.h
src/test/regress/expected/rules.out