Role standalone

Provisions a standalone PostgreSQL server

Variables

Name Value Description Required
backup_full_schedule <none> Systemd calendar schedule for full backups false
backup_incr_schedule --* 02:00:02 Systemd calendar schedule for incremental backups false
backup_password <none> S3 backup encryption password true
backup_s3_bucket <none> S3 backup bucket name true
backup_s3_endpoint <none> S3 backup bucket endpoint true
backup_s3_key <none> S3 backup bucket access key true
backup_s3_key_secret <none> S3 backup bucket secret access key true
backup_s3_region <none> S3 backup bucket region true
backup_s3_uri_style host S3 backup bucket uri style false
environment_name <none> environment name true
extension_pg_ivm_enabled false enable postgis postgres extension false
extension_pgaudit_enabled false enable pgaudit postgres extension false
extension_pglogical_enabled false enable pglogical postgres extension false
extension_pgvector_enabled false enable postgis postgres extension false
extension_postgis_enabled false enable postgis postgres extension false
extra_configuration --* 0/3:00:02 additional database configuration options as key/value pairs false
instance_name <none> database instance name true
postgres_version <none> postgres version to install false
primary_node {{ ansible_hostname }} <none> false
service_name {{ environment_name }}-{{ instance_name }} <none> false
stanza_name {{ service_name }} <none> false
superuser_password <none> database superuser password true
superuser_username <none> database superuser name false