1PG_AUTOCTL GET FORMATION SETTINGpSg(_1a)uto_failPoGv_eArUTOCTL GET FORMATION SETTINGS(1)
2
3
4

NAME

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

SYNOPSIS

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

DESCRIPTION

21       See also pg_autoctl_show_settings which is a synonym.
22

OPTIONS

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

EXAMPLES

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

AUTHOR

122       Microsoft
123
125       Copyright (c) Microsoft Corporation. All rights reserved.
126
127
128
129
1301.6                              Jan 21, 20P2G2_AUTOCTL GET FORMATION SETTINGS(1)
Impressum