1PG_AUTOCTL ENABLE SECONDARY(1) pg_auto_failover PG_AUTOCTL ENABLE SECONDARY(1)
2
3
4
6 pg_autoctl enable secondary - pg_autoctl enable secondary
7
8 pg_autoctl enable secondary - Enable secondary nodes on a formation
9
11 This feature makes the most sense when using the Enterprise Edition of
12 pg_auto_failover, which is fully compatible with Citus formations. When
13 secondary are enabled, then Citus workers creation policy is to assign
14 a primary node then a standby node for each group. When secondary is
15 disabled the Citus workers creation policy is to assign only the pri‐
16 mary nodes.
17
18 usage: pg_autoctl enable secondary [ --pgdata --formation ]
19
20 --pgdata path to data directory
21 --formation Formation to enable secondary on
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 --formation
31 Target formation where to enable secondary feature.
32
34 PGDATA
35 Postgres directory location. Can be used instead of the --pgdata op‐
36 tion.
37
38 PG_AUTOCTL_MONITOR
39 Postgres URI to connect to the monitor node, can be used instead of
40 the --monitor option.
41
42 XDG_CONFIG_HOME
43 The pg_autoctl command stores its configuration files in the stan‐
44 dard place XDG_CONFIG_HOME. See the XDG Base Directory Specifica‐
45 tion.
46
47 XDG_DATA_HOME
48 The pg_autoctl command stores its internal states files in the stan‐
49 dard place XDG_DATA_HOME, which defaults to ~/.local/share. See the
50 XDG Base Directory Specification.
51
53 Microsoft
54
56 Copyright (c) Microsoft Corporation. All rights reserved.
57
58
59
60
612.0 Sep 13, 2023 PG_AUTOCTL ENABLE SECONDARY(1)