Role standalone

Provisions a standalone PostgreSQL server

Variables

NameValueDescriptionRequired
backup_full_schedule--* 02:00:02Systemd calendar schedule for full backupsfalse
backup_incr_schedule--* 0/3:00:02Systemd calendar schedule for incremental backupsfalse
backup_password<none>S3 backup encryption passwordtrue
backup_s3_bucket<none>S3 backup bucket nametrue
backup_s3_endpoint<none>S3 backup bucket endpointtrue
backup_s3_key<none>S3 backup bucket access keytrue
backup_s3_key_secret<none>S3 backup bucket secret access keytrue
backup_s3_region<none>S3 backup bucket regiontrue
backup_s3_uri_stylehostS3 backup bucket uri stylefalse
environment_name<none>environment nametrue
extension_pg_ivm_enabledfalseenable postgis postgres extensionfalse
extension_pgaudit_enabledfalseenable pgaudit postgres extensionfalse
extension_pglogical_enabledfalseenable pglogical postgres extensionfalse
extension_pgvector_enabledfalseenable postgis postgres extensionfalse
extension_postgis_enabledfalseenable postgis postgres extensionfalse
extra_configuration<none>additional database configuration options as key/value pairsfalse
instance_name<none>database instance nametrue
postgres_version<none>postgres version to installfalse
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 passwordtrue
superuser_username<none>database superuser namefalse