---
name: "pg_cloudconfig"
section: "1"
platform: "linux"
package: "pg-cloudconfig"
version: "0.11"
release: "Debian 11 (Bullseye)"
platforms: ["linux"]
url: "https://new.carta.tech/pg_cloudconfig"
---

# pg\_cloudconfig(1)

set optimized defaults for PostgreSQL in virtualized environments

## 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.