1PG_AUTOCTL SHOW STANDBY-NAMES(1)pg_auto_failoverPG_AUTOCTL SHOW STANDBY-NAMES(1)
2
3
4

NAME

6       pg_autoctl show standby-names - pg_autoctl show standby-names
7
8       pg_autoctl  show standby-names - Prints synchronous_standby_names for a
9       given group
10

SYNOPSIS

12       This command prints the current value for synchronous_standby_names for
13       the primary Postgres server of the target group (default 0) in the tar‐
14       get formation (default default), as computed by the monitor:
15
16          usage: pg_autoctl show standby-names  [ --pgdata ] --formation --group
17
18            --pgdata      path to data directory
19            --monitor     pg_auto_failover Monitor Postgres URL
20            --formation   formation to query, defaults to 'default'
21            --group       group to query formation, defaults to all
22            --json        output data in the JSON format
23

OPTIONS

25       --pgdata
26              Location of the Postgres node being managed locally. Defaults to
27              the  environment  variable PGDATA. Use --monitor to connect to a
28              monitor from anywhere, rather than the monitor URI used by a lo‐
29              cal Postgres node managed with pg_autoctl.
30
31       --monitor
32              Postgres  URI  used  to connect to the monitor. Must use the au‐
33              toctl_node username and  target  the  pg_auto_failover  database
34              name.  It  is possible to show the Postgres URI from the monitor
35              node using the command pg_autoctl show uri.
36
37              Defaults  to  the  value  of  the  environment  variable  PG_AU‐
38              TOCTL_MONITOR.
39
40       --formation
41              Show  the  current synchronous_standby_names value for the given
42              formation. Defaults to the default formation.
43
44       --group
45              Show the current synchronous_standby_names value for  the  given
46              group in the given formation. Defaults to group 0.
47
48       --json Output a JSON formatted data instead of a table formatted list.
49

ENVIRONMENT

51       PGDATA
52          Postgres directory location. Can be used instead of the --pgdata op‐
53          tion.
54
55       PG_AUTOCTL_MONITOR
56          Postgres URI to connect to the monitor node, can be used instead  of
57          the --monitor option.
58
59       XDG_CONFIG_HOME
60          The  pg_autoctl  command stores its configuration files in the stan‐
61          dard place XDG_CONFIG_HOME. See the XDG  Base  Directory  Specifica‐
62          tion.
63
64       XDG_DATA_HOME
65          The pg_autoctl command stores its internal states files in the stan‐
66          dard place XDG_DATA_HOME, which defaults to ~/.local/share. See  the
67          XDG Base Directory Specification.
68

EXAMPLES

70          $ pg_autoctl show standby-names
71          'ANY 1 (pgautofailover_standby_2, pgautofailover_standby_3)'
72
73          $ pg_autoctl show standby-names --json
74          {
75              "formation": "default",
76              "group": 0,
77              "synchronous_standby_names": "ANY 1 (pgautofailover_standby_2, pgautofailover_standby_3)"
78          }
79

AUTHOR

81       Microsoft
82

84       Copyright (c) Microsoft Corporation. All rights reserved.
85
86
87
88
892.0                              Sep 13, 2023 PG_AUTOCTL SHOW STANDBY-NAMES(1)
Impressum