mirror of
https://github.com/EnterpriseDB/repmgr.git
synced 2026-03-23 15:16:29 +00:00
bd35b450da
Previously, if PostgreSQL was not running on the node, repmgrd and pause status were shown as "0", implying their status was known. This brings the csv output in line with the human-readable output, which displays "n/a" in this case.
187 lines
6.4 KiB
Plaintext
187 lines
6.4 KiB
Plaintext
<refentry id="repmgr-daemon-status">
|
|
<indexterm>
|
|
<primary>repmgr daemon status</primary>
|
|
</indexterm>
|
|
|
|
<indexterm>
|
|
<primary>repmgrd</primary>
|
|
<secondary>displaying daemon status</secondary>
|
|
</indexterm>
|
|
|
|
<refmeta>
|
|
<refentrytitle>repmgr daemon status</refentrytitle>
|
|
</refmeta>
|
|
|
|
<refnamediv>
|
|
<refname>repmgr daemon status</refname>
|
|
<refpurpose>display information about the status of <application>repmgrd</application> on each node in the cluster</refpurpose>
|
|
</refnamediv>
|
|
|
|
<refsect1>
|
|
<title>Description</title>
|
|
<para>
|
|
This command provides an overview over all active nodes in the cluster and the state
|
|
of each node's <application>repmgrd</application> instance. It can be used to check
|
|
the result of <xref linkend="repmgr-daemon-pause"> and <xref linkend="repmgr-daemon-unpause">
|
|
operations.
|
|
</para>
|
|
</refsect1>
|
|
|
|
<refsect1>
|
|
<title>Execution</title>
|
|
<para>
|
|
<command>repmgr daemon status</command> can be executed on any active node in the
|
|
replication cluster. A valid <filename>repmgr.conf</filename> file is required.
|
|
</para>
|
|
<para>
|
|
If PostgreSQL is not running on a node, &repmgr; will not be able to determine the
|
|
status of that node's <application>repmgrd</application> instance.
|
|
</para>
|
|
<note>
|
|
<para>
|
|
After restarting PostgreSQL on any node, the <application>repmgrd</application> instance
|
|
will take a second or two before it is able to update its status. Until then,
|
|
<application>repmgrd</application> will be shown as not running.
|
|
</para>
|
|
</note>
|
|
|
|
</refsect1>
|
|
|
|
<refsect1>
|
|
<title>Examples</title>
|
|
<para>
|
|
<application>repmgrd</application> running normally on all nodes:
|
|
<programlisting>$ repmgr -f /etc/repmgr.conf daemon status
|
|
ID | Name | Role | Priority | Status | repmgrd | PID | Paused? | Upstream last seen
|
|
----+-------+---------+----------+---------+---------+-------+---------+--------------------
|
|
1 | node1 | primary | 100 | running | running | 71987 | no | n/a
|
|
2 | node2 | standby | 100 | running | running | 71996 | no | 1 second(s) ago
|
|
3 | node3 | standby | 100 | running | running | 72042 | no | 1 second(s) ago
|
|
</programlisting>
|
|
</para>
|
|
|
|
<para>
|
|
<application>repmgrd</application> paused on all nodes (using <xref linkend="repmgr-daemon-pause">):
|
|
<programlisting>$ repmgr -f /etc/repmgr.conf daemon status
|
|
ID | Name | Role | Priority | Status | repmgrd | PID | Paused? | Upstream last seen
|
|
----+-------+---------+----------+---------+---------+-------+---------+--------------------
|
|
1 | node1 | primary | 100 | running | running | 71987 | yes | n/a
|
|
2 | node2 | standby | 100 | running | running | 71996 | yes | 0 second(s) ago
|
|
3 | node3 | standby | 100 | running | running | 72042 | yes | 0 second(s) ago
|
|
</programlisting>
|
|
</para>
|
|
|
|
<para>
|
|
<application>repmgrd</application> not running on one node:
|
|
<programlisting>$ repmgr -f /etc/repmgr.conf daemon status
|
|
ID | Name | Role | Priority | Status | repmgrd | PID | Paused? | Upstream last seen
|
|
----+-------+---------+----------+---------+-------------+-------+---------+--------------------
|
|
1 | node1 | primary | 100 | running | running | 71987 | yes | n/a
|
|
2 | node2 | standby | 100 | running | not running | n/a | n/a | n/a
|
|
3 | node3 | standby | 100 | running | running | 72042 | yes | 0 second(s) ago</programlisting>
|
|
</para>
|
|
</refsect1>
|
|
|
|
<refsect1>
|
|
<title>Options</title>
|
|
|
|
<variablelist>
|
|
|
|
<varlistentry>
|
|
<term><option>--csv</option></term>
|
|
<listitem>
|
|
<para>
|
|
<command>repmgr daemon status</command> accepts an optional parameter <literal>--csv</literal>, which
|
|
outputs the replication cluster's status in a simple CSV format, suitable for
|
|
parsing by scripts, e.g.:
|
|
<programlisting>
|
|
$ repmgr -f /etc/repmgr.conf daemon status --csv
|
|
1,node1,primary,1,1,5722,1,100,-1
|
|
2,node2,standby,1,0,-1,1,100,1
|
|
3,node3,standby,1,1,5779,1,100,1</programlisting>
|
|
</para>
|
|
<para>
|
|
The columns have following meanings:
|
|
<itemizedlist spacing="compact" mark="bullet">
|
|
<listitem>
|
|
<simpara>
|
|
node ID
|
|
</simpara>
|
|
</listitem>
|
|
|
|
<listitem>
|
|
<simpara>
|
|
node name
|
|
</simpara>
|
|
</listitem>
|
|
|
|
<listitem>
|
|
<simpara>
|
|
node type (primary or standby)
|
|
</simpara>
|
|
</listitem>
|
|
|
|
<listitem>
|
|
<simpara>
|
|
PostgreSQL server running (1 = running, 0 = not running)
|
|
</simpara>
|
|
</listitem>
|
|
|
|
<listitem>
|
|
<simpara>
|
|
<application>repmgrd</application> running (1 = running, 0 = not running, -1 = unknown)
|
|
</simpara>
|
|
</listitem>
|
|
|
|
<listitem>
|
|
<simpara>
|
|
<application>repmgrd</application> PID (-1 if not running or status unknown)
|
|
</simpara>
|
|
</listitem>
|
|
|
|
<listitem>
|
|
<simpara>
|
|
<application>repmgrd</application> paused (1 = paused, 0 = not paused, -1 = unknown)
|
|
</simpara>
|
|
</listitem>
|
|
|
|
<listitem>
|
|
<simpara>
|
|
<application>repmgrd</application> node priority
|
|
</simpara>
|
|
</listitem>
|
|
|
|
<listitem>
|
|
<simpara>
|
|
interval in seconds since the node's upstream was last seen (this will be -1 if the value could not be retrieved, or the node is primary)
|
|
</simpara>
|
|
</listitem>
|
|
|
|
</itemizedlist>
|
|
</para>
|
|
</listitem>
|
|
</varlistentry>
|
|
|
|
<varlistentry>
|
|
<term><option>--verbose</option></term>
|
|
<listitem>
|
|
<para>
|
|
Display the full text of any database connection error messages
|
|
</para>
|
|
</listitem>
|
|
</varlistentry>
|
|
|
|
</variablelist>
|
|
|
|
</refsect1>
|
|
|
|
|
|
|
|
<refsect1>
|
|
<title>See also</title>
|
|
<para>
|
|
<xref linkend="repmgr-daemon-pause">, <xref linkend="repmgr-daemon-unpause">, <xref linkend="repmgr-cluster-show">
|
|
</para>
|
|
</refsect1>
|
|
</refentry>
|