1PG_AUTOCTL GET FORMATION SETTINGpSg(_1a)uto_failPoGv_eArUTOCTL GET FORMATION SETTINGS(1)
2
3
4
6 pg_autoctl get formation settings - pg_autoctl get formation settings
7
8 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
14 usage: pg_autoctl get formation settings [ --pgdata ] [ --json ] [ --formation ]
15
16 --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
30 --json Output JSON formated data.
31
32 --formation
33 Show replication settings for given formation. Defaults to de‐
34 fault.
35
37 $ pg_autoctl get formation settings
38 Context | Name | Setting | Value
39 ----------+---------+---------------------------+-------------------------------------------------------------
40 formation | default | number_sync_standbys | 1
41 primary | node1 | synchronous_standby_names | 'ANY 1 (pgautofailover_standby_2, pgautofailover_standby_3)'
42 node | node1 | candidate priority | 50
43 node | node2 | candidate priority | 50
44 node | node3 | candidate priority | 50
45 node | node1 | replication quorum | true
46 node | node2 | replication quorum | true
47 node | node3 | replication quorum | true
48
49 $ pg_autoctl get formation settings --json
50 {
51 "nodes": [
52 {
53 "value": "true",
54 "context": "node",
55 "node_id": 1,
56 "setting": "replication quorum",
57 "group_id": 0,
58 "nodename": "node1"
59 },
60 {
61 "value": "true",
62 "context": "node",
63 "node_id": 2,
64 "setting": "replication quorum",
65 "group_id": 0,
66 "nodename": "node2"
67 },
68 {
69 "value": "true",
70 "context": "node",
71 "node_id": 3,
72 "setting": "replication quorum",
73 "group_id": 0,
74 "nodename": "node3"
75 },
76 {
77 "value": "50",
78 "context": "node",
79 "node_id": 1,
80 "setting": "candidate priority",
81 "group_id": 0,
82 "nodename": "node1"
83 },
84 {
85 "value": "50",
86 "context": "node",
87 "node_id": 2,
88 "setting": "candidate priority",
89 "group_id": 0,
90 "nodename": "node2"
91 },
92 {
93 "value": "50",
94 "context": "node",
95 "node_id": 3,
96 "setting": "candidate priority",
97 "group_id": 0,
98 "nodename": "node3"
99 }
100 ],
101 "primary": [
102 {
103 "value": "'ANY 1 (pgautofailover_standby_2, pgautofailover_standby_3)'",
104 "context": "primary",
105 "node_id": 1,
106 "setting": "synchronous_standby_names",
107 "group_id": 0,
108 "nodename": "node1"
109 }
110 ],
111 "formation": {
112 "value": "1",
113 "context": "formation",
114 "node_id": null,
115 "setting": "number_sync_standbys",
116 "group_id": null,
117 "nodename": "default"
118 }
119 }
120
122 Microsoft
123
125 Copyright (c) Microsoft Corporation. All rights reserved.
126
127
128
129
1301.6 Nov 24, 20P2G1_AUTOCTL GET FORMATION SETTINGS(1)