postgresql

Deploy PostgreSQL as a Podman quadlet.

Usage

- hosts: all
  roles:
    - role: giftpilz0.container.postgresql

Variables

podman_userstr
System user for rootless podman operations.
Default{{ ansible_user }}
postgresql_imagestr
Image name without tag.
Defaultdocker.io/library/postgres
postgresql_versionstr
Container image version.
Default18.6-alpine
postgresql_autoupdatebool
Enable podman auto-update for PostgreSQL.
Defaulttrue
postgresql_backup_autoupdatebool
Enable podman auto-update for the backup container.
Defaulttrue
postgresql_network_enabledbool
Create and manage the podman network.
Defaulttrue
postgresql_network_namestr
Podman network name.
Defaultpostgresql-internal
postgresql_network_driverstr
Podman network driver.
Defaultbridge
postgresql_port_map_enabledbool
Expose container ports on the host.
Defaultfalse
postgresql_bind_ipstr
Host IP to bind exposed ports to.
Default127.0.0.1
postgresql_port_maplist[str]
Host:container port mappings.
Default- 5432:5432
postgresql_log_destinationstr
PostgreSQL log destination.
Defaultstderr
postgresql_log_statementstr
SQL statement logging level.
Choicesnoneddlmodall
Defaultnone
postgresql_log_min_duration_statementint
Log statements running at least this many milliseconds.
Default1000
postgresql_log_connectionsbool
Log successful connection attempts.
Defaulttrue
postgresql_log_disconnectionsbool
Log session disconnections.
Defaulttrue
postgresql_log_checkpointsbool
Log checkpoint activity.
Defaulttrue
postgresql_log_lock_waitsbool
Log waits exceeding deadlock timeout.
Defaulttrue
postgresql_log_line_prefixstr
Context prefix for each PostgreSQL log line.
Default%m [%p] db=%d,user=%u,app=%a,client=%h
postgresql_admin_databasestr
Administrator database created by the PostgreSQL image.
Defaultpostgres
postgresql_admin_userstr
Administrator user created by the PostgreSQL image.
Defaultpostgres
postgresql_admin_passwordstr
Password for the PostgreSQL administrator user.
Default""
postgresql_userslist[dict]
Users to provision; each entry has name and password.
Default[]
postgresql_databaseslist[dict]
Secondary databases to provision and include in backups; each entry has name and owner.
Default[]
postgresql_backup_schedule_timesstr
Time of day to run backup (HH:MM format).
Default03:00
postgresql_backup_retention_daysint
Number of days to keep backups.
Default7
postgresql_backup_compressionint
Gzip compression level (1-9).
Default6

postgresql_environment_varsdict

Extra environment variables for the container.

Default

POSTGRES_DB: '{{ postgresql_admin_database }}'
POSTGRES_USER: '{{ postgresql_admin_user }}'
POSTGRES_PASSWORD: '{{ postgresql_admin_password }}'

postgresql_entrypointstr
Optional PostgreSQL container entrypoint override.
Default""
postgresql_backup_entrypointstr
Optional PostgreSQL backup container entrypoint override.
Default""
postgresql_extra_fileslist[dict]
Arbitrary file entries with src (controller path) or source (target path), dest, optional mount, mode, and template.
Default[]
postgresql_extra_dirslist[dict]
Arbitrary directory entries with src (controller directory) or source (target path), dest, optional mount and mode.
Default[]