postgresql/README.md

Deploy PostgreSQL

Install ansible and requirements in virtualenv

mkvirtualenv ansible-7.6.0
pip install -r requirements.txt
deactivate
workon ansible-7.6.0

Install roles

ansible-playbook ansible-roles.yaml

Install PostgreSQL

ansible-playbook -i inventory/hosts postgresql.yaml -u almalinux

PostgreSQL options example

postgresql_custom_parameters:
  max_connections: '2000'

Backup options example

postgresql_wal_g_install: true
wal_g_config: >-
  {{
  {
    "AWS_ACCESS_KEY_ID": "YOUR_ACCESS_KEY_ID",
    "AWS_SECRET_ACCESS_KEY": "YOUR_SECRET_ACCESS_KEY",
    "AWS_ENDPOINT": "https://s3.amazon.com",
    "WALG_S3_PREFIX": "s3://wal-g/pgsql-1",
    "WALG_LIBSODIUM_KEY": "29b43e2f46adcaf9f0d635d9fe4934e3227b3cbd13e2b19c7b28c16a581cc15c"
    "AWS_S3_FORCE_PATH_STYLE": "true"
  }
  }}