diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2017-11-01 14:32:05 -0400 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2017-11-01 14:32:05 -0400 |
| commit | ec7ce54204147ccf1a55aaba526ac4b39071f712 (patch) | |
| tree | b9aa02205403711d511b88be50ea28123288d72e | |
| parent | af20e2d728eb508bb169e7294e4e210a3459833a (diff) | |
| download | postgresql-ec7ce54204147ccf1a55aaba526ac4b39071f712.tar.gz postgresql-ec7ce54204147ccf1a55aaba526ac4b39071f712.zip | |
doc: Mention pg_stat_wal_receiver in streaming replication docs
Also make the link to pg_stat_replication more precise.
Author: Michael Paquier <michael.paquier@gmail.com>
Reviewed-by: Jeff Janes <jeff.janes@gmail.com>
| -rw-r--r-- | doc/src/sgml/high-availability.sgml | 10 |
1 files changed, 8 insertions, 2 deletions
diff --git a/doc/src/sgml/high-availability.sgml b/doc/src/sgml/high-availability.sgml index aa780d360dc..6c0679b0a8b 100644 --- a/doc/src/sgml/high-availability.sgml +++ b/doc/src/sgml/high-availability.sgml @@ -890,14 +890,20 @@ primary_conninfo = 'host=192.168.1.50 port=5432 user=foo password=foopass' </para> <para> You can retrieve a list of WAL sender processes via the - <link linkend="monitoring-stats-views-table"> - <literal>pg_stat_replication</literal></link> view. Large differences between + <xref linkend="pg-stat-replication-view"> view. Large differences between <function>pg_current_wal_lsn</function> and the view's <literal>sent_lsn</literal> field might indicate that the master server is under heavy load, while differences between <literal>sent_lsn</literal> and <function>pg_last_wal_receive_lsn</function> on the standby might indicate network delay, or that the standby is under heavy load. </para> + <para> + On a hot standby, the status of the WAL receiver process can be retrieved + via the <xref linkend="pg-stat-wal-receiver-view"> view. A large + difference between <function>pg_last_wal_replay_lsn</function> and the + view's <literal>received_lsn</literal> indicates that WAL is being + received faster than it can be replayed. + </para> </sect3> </sect2> |