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 formated data.
41
42       --formation
43              Show  replication  settings for given formation. Defaults to de‐
44              fault.
45

AUTHOR

47       Microsoft
48

50       Copyright (c) Microsoft Corporation. All rights reserved.
51
52
53
54
551.6                           PG_AAuUgTO0C4T,L 2S0E2T2FORMATION NUMBER-SYNC-STANDBYS(1)
Impressum