Scroll to navigation

PG_CLOUDCONFIG(1) User Commands PG_CLOUDCONFIG(1)

NAME

pg_cloudconfig - set optimized defaults for PostgreSQL in virtualized environments

DESCRIPTION

usage: pg_cloudconfig [-h] [--max_connections MAX_CONNECTIONS]
[--pg_conf_dir PG_CONF_DIR] [--dynamic_only]
[--blacklist SETTING [SETTING ...]] [--debug] [-q] [--version] pg_version pg_clustername

Tool to initially set optimized defaults for PostgreSQL in virtualized environments. Settings are changed without asking for confirmation.

positional arguments:

pg_version
version of the PostgreSQL cluster to tune
pg_clustername
name of the PostgreSQL cluster to tune

optional arguments:

-h, --help
show this help message and exit
--max_connections MAX_CONNECTIONS
set the max_connections explicitly if needed
--pg_conf_dir PG_CONF_DIR
path to dir holding the postgresql.conf (to override default)
--dynamic_only
do not set static optimized defaults, only set values dynamic calculated
--blacklist SETTING [SETTING ...]
settings not to touch
--debug
show debug messages
-q, --quiet
disable output
--version
show program's version number and exit

pg_cloudconfig should be run as the same user as PostgreSQL. pg_version and pg_clustername are used to choose a cluster. It is assumed that the Debian / postgresql-common naming and configuration schema is used. If this is not the case --pg_conf_dir needs to be set. pg_conftool is used to get/set settings. This does not tune PostgreSQL for any specific workload but only tries to set some optimized defaults based on a few input variables and simple rules.

October 2018 pg_cloudconfig 0.10