1PG_AUTOCTL CONFIG CHECK(1)     pg_auto_failover     PG_AUTOCTL CONFIG CHECK(1)
2
3
4

NAME

6       pg_autoctl config check - pg_autoctl config check
7
8       pg_autoctl config check - Check pg_autoctl configuration
9

SYNOPSIS

11       This command implements a very basic list of sanity checks for a pg_au‐
12       toctl node setup:
13
14          usage: pg_autoctl config check  [ --pgdata ] [ --json ]
15
16          --pgdata      path to data directory
17          --json        output data in the JSON format
18

OPTIONS

20       --pgdata
21              Location of the Postgres node being managed locally. Defaults to
22              the  environment  variable PGDATA. Use --monitor to connect to a
23              monitor from anywhere, rather than the monitor URI used by a lo‐
24              cal Postgres node managed with pg_autoctl.
25
26       --json Output JSON formatted data.
27

ENVIRONMENT

29       PGDATA
30          Postgres directory location. Can be used instead of the --pgdata op‐
31          tion.
32
33       PG_AUTOCTL_MONITOR
34          Postgres URI to connect to the monitor node, can be used instead  of
35          the --monitor option.
36
37       XDG_CONFIG_HOME
38          The  pg_autoctl  command stores its configuration files in the stan‐
39          dard place XDG_CONFIG_HOME. See the XDG  Base  Directory  Specifica‐
40          tion.
41
42       XDG_DATA_HOME
43          The pg_autoctl command stores its internal states files in the stan‐
44          dard place XDG_DATA_HOME, which defaults to ~/.local/share. See  the
45          XDG Base Directory Specification.
46

EXAMPLES

48          $ pg_autoctl config check --pgdata node1
49          18:37:27 63749 INFO  Postgres setup for PGDATA "/Users/dim/dev/MS/pg_auto_failover/tmux/node1" is ok, running with PID 5501 and port 99698
50          18:37:27 63749 INFO  Connection to local Postgres ok, using "port=5501 dbname=demo host=/tmp"
51          18:37:27 63749 INFO  Postgres configuration settings required for pg_auto_failover are ok
52          18:37:27 63749 WARN  Postgres 12.1 does not support replication slots on a standby node
53          18:37:27 63749 INFO  Connection to monitor ok, using "postgres://autoctl_node@localhost:5500/pg_auto_failover?sslmode=prefer"
54          18:37:27 63749 INFO  Monitor is running version "1.5.0.1", as expected
55          pgdata:                /Users/dim/dev/MS/pg_auto_failover/tmux/node1
56          pg_ctl:                /Applications/Postgres.app/Contents/Versions/12/bin/pg_ctl
57          pg_version:            12.3
58          pghost:                /tmp
59          pgport:                5501
60          proxyport:             0
61          pid:                   99698
62          is in recovery:        no
63          Control Version:       1201
64          Catalog Version:       201909212
65          System Identifier:     6941034382470571312
66          Latest checkpoint LSN: 0/6000098
67          Postmaster status:     ready
68

AUTHOR

70       Microsoft
71

73       Copyright (c) Microsoft Corporation. All rights reserved.
74
75
76
77
782.0                              Sep 13, 2023       PG_AUTOCTL CONFIG CHECK(1)
Impressum