1PG_AUTOCTL GET FORMATION SETTINGpSg(_1a)uto_failPoGv_eArUTOCTL GET FORMATION SETTINGS(1)
2
6 pg_autoctl get formation settings - pg_autoctl get formation settings
7 pg_autoctl get formation settings - get replication settings for a for‐
9 mation from the monitor
10
12 This command prints a pg_autoctl replication settings:
13 usage: pg_autoctl get formation settings [ --pgdata ] [ --json ] [ --formation ]
15 --pgdata path to data directory
17 --json output data in the JSON format
18 --formation pg_auto_failover formation
19
21 See also pg_autoctl show settings which is a synonym.
22
24 --pgdata
25 Location of the Postgres node being managed locally. Defaults to
26 the environment variable PGDATA. Use --monitor to connect to a
27 monitor from anywhere, rather than the monitor URI used by a lo‐
28 cal Postgres node managed with pg_autoctl.
29 --json Output JSON formatted data.
31 --formation
33 Show replication settings for given formation. Defaults to de‐
34 fault.
35
37 PGDATA
38 Postgres directory location. Can be used instead of the --pgdata op‐
39 tion.
40 PG_AUTOCTL_MONITOR
42 Postgres URI to connect to the monitor node, can be used instead of
43 the --monitor option.
44 XDG_CONFIG_HOME
46 The pg_autoctl command stores its configuration files in the stan‐
47 dard place XDG_CONFIG_HOME. See the XDG Base Directory Specifica‐
48 tion.
49 XDG_DATA_HOME
51 The pg_autoctl command stores its internal states files in the stan‐
52 dard place XDG_DATA_HOME, which defaults to ~/.local/share. See the
53 XDG Base Directory Specification.
54
56 $ pg_autoctl get formation settings
57 Context | Name | Setting | Value
58 ----------+---------+---------------------------+-------------------------------------------------------------
59 formation | default | number_sync_standbys | 1
60 primary | node1 | synchronous_standby_names | 'ANY 1 (pgautofailover_standby_2, pgautofailover_standby_3)'
61 node | node1 | candidate priority | 50
62 node | node2 | candidate priority | 50
63 node | node3 | candidate priority | 50
64 node | node1 | replication quorum | true
65 node | node2 | replication quorum | true
66 node | node3 | replication quorum | true
67 $ pg_autoctl get formation settings --json
69 {
70 "nodes": [
71 {
72 "value": "true",
73 "context": "node",
74 "node_id": 1,
75 "setting": "replication quorum",
76 "group_id": 0,
77 "nodename": "node1"
78 },
79 {
80 "value": "true",
81 "context": "node",
82 "node_id": 2,
83 "setting": "replication quorum",
84 "group_id": 0,
85 "nodename": "node2"
86 },
87 {
88 "value": "true",
89 "context": "node",
90 "node_id": 3,
91 "setting": "replication quorum",
92 "group_id": 0,
93 "nodename": "node3"
94 },
95 {
96 "value": "50",
97 "context": "node",
98 "node_id": 1,
99 "setting": "candidate priority",
100 "group_id": 0,
101 "nodename": "node1"
102 },
103 {
104 "value": "50",
105 "context": "node",
106 "node_id": 2,
107 "setting": "candidate priority",
108 "group_id": 0,
109 "nodename": "node2"
110 },
111 {
112 "value": "50",
113 "context": "node",
114 "node_id": 3,
115 "setting": "candidate priority",
116 "group_id": 0,
117 "nodename": "node3"
118 }
119 ],
120 "primary": [
121 {
122 "value": "'ANY 1 (pgautofailover_standby_2, pgautofailover_standby_3)'",
123 "context": "primary",
124 "node_id": 1,
125 "setting": "synchronous_standby_names",
126 "group_id": 0,
127 "nodename": "node1"
128 }
129 ],
130 "formation": {
131 "value": "1",
132 "context": "formation",
133 "node_id": null,
134 "setting": "number_sync_standbys",
135 "group_id": null,
136 "nodename": "default"
137 }
138 }
139
141 Microsoft
142
144 Copyright (c) Microsoft Corporation. All rights reserved.
1452.0 Sep 13, 20P2G3_AUTOCTL GET FORMATION SETTINGS(1)