1PG_AUTOCTL SET FORMATION NUMBERP-pGSg_Y_ANaUCuT-tOSoCT_TAfLNaDiSBlEYoTSv(eF1rO)RMATION NUMBER-SYNC-STANDBYS(1)
2
3
4

NAME

6       pg_autoctl  set  formation number-sync-standbys - pg_autoctl set forma‐
7       tion number-sync-standbys
8
9       pg_autoctl set formation number-sync-standbys - set  number_sync_stand‐
10       bys for a formation from the monitor
11

SYNOPSIS

13       This  command  set  a  pg_autoctl  replication settings for number sync
14       standbys:
15
16          usage: pg_autoctl set formation number-sync-standbys  [ --pgdata ] [ --json ] [ --formation ] <number_sync_standbys>
17
18          --pgdata      path to data directory
19          --formation   pg_auto_failover formation
20          --json        output data in the JSON format
21

DESCRIPTION

23       The pg_auto_failover  monitor  ensures  that  at  least  N+1  candidate
24       standby nodes are registered when number-sync-standbys is N. This means
25       that to be able to run the following command, at least 3 standby  nodes
26       with a non-zero candidate priority must be registered to the monitor:
27
28          $ pg_autoctl set formation number-sync-standbys 2
29
30       See also pg_autoctl show settings for the full list of replication set‐
31       tings.
32

OPTIONS

34       --pgdata
35              Location of the Postgres node being managed locally. Defaults to
36              the  environment  variable PGDATA. Use --monitor to connect to a
37              monitor from anywhere, rather than the monitor URI used by a lo‐
38              cal Postgres node managed with pg_autoctl.
39
40       --json Output JSON formatted data.
41
42       --formation
43              Show  replication  settings for given formation. Defaults to de‐
44              fault.
45

ENVIRONMENT

47       PGDATA
48          Postgres directory location. Can be used instead of the --pgdata op‐
49          tion.
50
51       PG_AUTOCTL_MONITOR
52          Postgres  URI to connect to the monitor node, can be used instead of
53          the --monitor option.
54
55       XDG_CONFIG_HOME
56          The pg_autoctl command stores its configuration files in  the  stan‐
57          dard  place  XDG_CONFIG_HOME.  See the XDG Base Directory Specifica‐
58          tion.
59
60       XDG_DATA_HOME
61          The pg_autoctl command stores its internal states files in the stan‐
62          dard  place XDG_DATA_HOME, which defaults to ~/.local/share. See the
63          XDG Base Directory Specification.
64

AUTHOR

66       Microsoft
67

69       Copyright (c) Microsoft Corporation. All rights reserved.
70
71
72
73
742.0                           PG_SAeUpTO1C3T,L 2S0E2T3FORMATION NUMBER-SYNC-STANDBYS(1)
Impressum