Standalone deployment variables

This table describes all the fields available in the YaK and their purpose when declaring your YaK PostgreSQL 2.1.0 standalone component.

Basic variables

Scroll right to see all columns.

Name	Mandatory	Purpose	Example
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

Advanced variables

Scroll right to see all columns.

Mandatory

Name	Mandatory	Purpose	Example
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)	[e-mail],[e-mail]