Get Postgres Tips and Tricks
Subscribe to get advanced Postgres how-tos.
CHECK-CONFIG¶
The CHECK-CONFIG
subcommand checks the parameter settings in the BART
configuration file as well as the database server configuration for
which the -s
option is specified.
Syntax:
bart CHECK-CONFIG [ –s <server_name> ]
In the above syntax diagram, CHECK-CONFIG
is the BART subcommand and –s
<server_name>
is the subcommand option.
Option
-s
(or --server) <server_name>
<server_name>
is the name of the database server whose configuration parameter settings are to be checked. If you do not specify the <server_name>
, the settings of the
BART configuration file global section are checked.
Example
The following example demonstrates a bart CHECK-CONFIG
command
without the –s
option. It successfully checks the global section of the
BART configuration file:
bash-4.1$ bart CHECK-CONFIG
INFO: Verifying that pg_basebackup is executable
INFO: success -
INFO: success - pg_basebackup(/usr/edb/as11/bin/pg_basebackup) returns
version 11.400000
The following example demonstrates executing a bart CHECK-CONFIG
command
with the –s
option. It successfully checks the database server parameter
settings:
[edb@localhost bin]$ ./bart check-config -s hr
INFO: Checking server hr
INFO: Verifying cluster_owner and ssh/scp connectivity
INFO: success
INFO: Verifying user, host, and replication connectivity
INFO: success
INFO: Verifying that user is a database superuser
INFO: success
INFO: Verifying that cluster_owner can read cluster data files
INFO: success
INFO: Verifying that you have permission to write to vault
INFO: success
INFO: /home/edb/bkup_new/hr
INFO: Verifying database server configuration
INFO: success
INFO: Verifying that WAL archiving is working
INFO: waiting 30 seconds for
/home/edb/bkup_new/hr/archived_wals/00000001000000000000001E
INFO: success
INFO: Verifying that bart-scanner is configured and running
INFO: success