PostgreSQL configuration¶

Instances created by pglift have their configuration managed. This is handled by writing configuration items into postgresql.conf within instance’s data directory.

Instance configuration is built from site-wise postgresql.conf file (which may be overridden). The default postgresql.conf template file contains:

postgresql/postgresql.conf¶

cluster_name = {name}
shared_buffers = 25%
effective_cache_size = 66%
unix_socket_directories = {settings.socket_directory}
log_directory = {settings.logpath}
log_filename = '{version}-{name}-%Y-%m-%d_%H%M%S.log'
log_destination = 'stderr'
logging_collector = on

Memory settings (shared_buffers and effective_cache_size) may be specified as a percentage of total system memory. Some PostgreSQL settings are computed from the postgresql section of the site-settings:

unix_socket_directories is based on the socket_directory
log_directory is based on the logpath

Note

If postgresql.logpath setting is set to null, the settings.logpath substitution variable for log_directory must not be used.

Additionally, the {name} and {version} template variables may be used (referring to the instance name and PostgreSQL version).

Then, some satellite components (e.g. pgBackRest) may define some PostgreSQL configuration settings they might need for proper operation.

Finally, any user-supplied value (e.g. the port or locale options or any other one provided through, e.g., the Ansible module) overrides the configuration:

$ pglift instance create --port=5678 --locale=fr_FR --encoding=latin1 main
$ pglift instance exec main -- psql -c "select name, setting from pg_settings where source = 'configuration file';"
          name           |                                                         setting
-------------------------+--------------------------------------------------------------------------------------------------------------------------
 archive_command         | /usr/bin/pgbackrest --config-path=/etc/pgbackrest --stanza=14-main archive-push %p
 archive_mode            | on
 cluster_name            | main
 effective_cache_size    | 524288
 lc_messages             | fr_FR
 lc_monetary             | fr_FR
 lc_numeric              | fr_FR
 lc_time                 | fr_FR
 log_destination         | stderr
 logging_collector       | on
 port                    | 5678
 shared_buffers          | 131072
 unix_socket_directories | /run/user/1000/pglift/postgresql
 wal_level               | replica
(14 rows)