Skip to main content

Configuration

This section guides you through the process of changes your PostgreSQL cluster configuration.

Console (UI)​

Cluster configuration changes are currently supported only through the command line.

tip

If you’re interested in having this functionality available through the UI, please consider becoming a sponsor.

Command line​

To change the PostgreSQL configuration in a cluster using automation:

  1. Modify the desired parameters in the variable file (e.g., postgresql_parameters).
  2. Run the config_pgcluster.yml playbook to apply the changes.

Example:

docker run --rm -it \
  -e ANSIBLE_SSH_ARGS="-F none" \
  -e ANSIBLE_INVENTORY=/autobase/inventory \
  -v $PWD/inventory:/autobase/inventory \
  -v $PWD/vars.yml:/vars.yml \
  -v $HOME/.ssh:/root/.ssh \
  autobase/automation:2.3.0 \
    ansible-playbook config_pgcluster.yml -e "@/vars.yml"
note

Optionally, set pending_restart: true to automatically restart PostgreSQL if the parameter change requires a restart.

info

You can use GitOps and CI/CD pipelines to manage PostgreSQL configuration in a fully automated and reproducible way.