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 formated data instead of a table formatted list.
49

EXAMPLES

51          $ pg_autoctl show standby-names
52          'ANY 1 (pgautofailover_standby_2, pgautofailover_standby_3)'
53
54          $ pg_autoctl show standby-names --json
55          {
56              "formation": "default",
57              "group": 0,
58              "synchronous_standby_names": "ANY 1 (pgautofailover_standby_2, pgautofailover_standby_3)"
59          }
60

AUTHOR

62       Microsoft
63
65       Copyright (c) Microsoft Corporation. All rights reserved.
66
67
68
69
701.6                              Aug 04, 2022 PG_AUTOCTL SHOW STANDBY-NAMES(1)
Impressum