HA deployment variables
This table describes all the fields available in the YaK and their purpose when declaring your YaK PostgreSQL 2.1.0 HA component.
Scroll right to see all columns.
Version of the PostgreSQL instance
Version of PostgreSQL you want to install
16.4
Apply OS prerequisites
Tick the box if you want to apply the OS prerequisites automatically on the target host (usually needed on Cloud servers). Untick if the OS prerequisites are already applied on the target host
true or false
Installation type
Installation using PostgreSQL source code and in-place compilation ("src") or using pre-compiled PostgreSQL binaries ("bin"). "bin" only available for Red Hat Enterprise Linux and Debian (SUSE Linux Enterprise Server will come later).
"src" or "bin"
Instance name
Name of the PostgreSQL instance/cluster (https://www.postgresql.org/docs/current/runtime-config-logging.html#GUC-CLUSTER-NAME)
PG01
Instance port
TCP/IP port the PostgreSQL instance listens on. The port must be different for each instance/cluster (https://www.postgresql.org/docs/current/runtime-config-connection.html#GUC-PORT)
1521
Log time zone
Time zone used for timestamps written to the instance log (https://www.postgresql.org/docs/16/runtime-config-logging.html#GUC-LOG-TIMEZONE)
Europe/Zurich
Scroll right to see all columns.
PostgreSQL user home directory
Home directory of the PostgreSQL OS user
/home/postgres
PostgreSQL extensions to install
List of extensions you want to install in 'template1' database of the PostgreSQL instance
pg_stat_statements, pg_prewarm, pg_trgm
Mount point for PostgreSQL binaries
Mount point where the PostgreSQL binaries will be installed (usually /u01)
/u01
Mount point for PostgreSQL data
Mount point where the PostgreSQL data will be stored (usually /u02)
/u02
Mount point for PostgreSQL archived WAL
Mount point where the PostgreSQL archived WAL will be stored (usually /u90)
/u90
Deployment with root privilege
Untick the box if the ansible user don't have root privileges on the target host(s). More details here.
SMTP server
IP or Hostname of the smtp server or relay host for pgBackRest and pg_dump notifications (DMK setting)
localhost
Mail from
Email address from which the notifications are send (DMK setting)
postgres@localhost
Mail to
Comma separated list of email addresses to which the notifications are send (DMK setting)
dba@example.com,servicedesk@example.com
Load Balancer type
Load Balancer / VIP to use. Only Keepalived, Azure Load Balancer and AWS Network Load Balancer are supported for now.
AWS
Last updated