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:

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

optional arguments:

show this help message and exit
set the max_connections explicitly if needed
path to dir holding the postgresql.conf (to override default)
do not set static optimized defaults, only set values dynamic calculated
settings not to touch
show debug messages
disable output
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 2019 pg_cloudconfig 0.11