diff options
| -rw-r--r-- | doc/src/sgml/high-availability.sgml | 6 | ||||
| -rw-r--r-- | doc/src/sgml/monitoring.sgml | 51 |
2 files changed, 55 insertions, 2 deletions
diff --git a/doc/src/sgml/high-availability.sgml b/doc/src/sgml/high-availability.sgml index 5bedaf27a29..6b89507c8c9 100644 --- a/doc/src/sgml/high-availability.sgml +++ b/doc/src/sgml/high-availability.sgml @@ -1161,6 +1161,10 @@ synchronous_standby_names = '2 (s1, s2, s3)' <literal>s2</> fails. <literal>s4</> is an asynchronous standby since its name is not in the list. </para> + <para> + The synchronous states of standby servers can be viewed using + the <structname>pg_stat_replication</structname> view. + </para> </sect3> <sect3 id="synchronous-replication-performance"> @@ -1235,6 +1239,8 @@ synchronous_standby_names = '2 (s1, s2, s3)' will increase according to the length of time the standby has been down. The standby is only able to become a synchronous standby once it has reached <literal>streaming</> state. + This state can be viewed using + the <structname>pg_stat_replication</structname> view. </para> <para> diff --git a/doc/src/sgml/monitoring.sgml b/doc/src/sgml/monitoring.sgml index 02dab879d9b..128ee13b5f7 100644 --- a/doc/src/sgml/monitoring.sgml +++ b/doc/src/sgml/monitoring.sgml @@ -1357,7 +1357,33 @@ SELECT pid, wait_event_type, wait_event FROM pg_stat_activity WHERE wait_event i <row> <entry><structfield>state</></entry> <entry><type>text</></entry> - <entry>Current WAL sender state</entry> + <entry>Current WAL sender state. + Possible values are: + <itemizedlist> + <listitem> + <para> + <literal>startup</>: This WAL sender is starting up. + </para> + </listitem> + <listitem> + <para> + <literal>catchup</>: This WAL sender's connected standby is + catching up with the primary. + </para> + </listitem> + <listitem> + <para> + <literal>streaming</>: This WAL sender is streaming changes + after its connected standby server has caught up with the primary. + </para> + </listitem> + <listitem> + <para> + <literal>backup</>: This WAL sender is sending a backup. + </para> + </listitem> + </itemizedlist> + </entry> </row> <row> <entry><structfield>sent_location</></entry> @@ -1391,7 +1417,28 @@ SELECT pid, wait_event_type, wait_event FROM pg_stat_activity WHERE wait_event i <row> <entry><structfield>sync_state</></entry> <entry><type>text</></entry> - <entry>Synchronous state of this standby server</entry> + <entry>Synchronous state of this standby server. + Possible values are: + <itemizedlist> + <listitem> + <para> + <literal>async</>: This standby server is asynchronous. + </para> + </listitem> + <listitem> + <para> + <literal>potential</>: This standby server is now asynchronous, + but can potentially become synchronous if one of current + synchronous ones fails. + </para> + </listitem> + <listitem> + <para> + <literal>sync</>: This standby server is synchronous. + </para> + </listitem> + </itemizedlist> + </entry> </row> </tbody> </tgroup> |