> For the complete documentation index, see [llms.txt](https://dbi-services.gitbook.io/yak-user-doc/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://dbi-services.gitbook.io/yak-user-doc/manage-components/component-types/postgresql/component-references/component-references-1/ha-deployment-variables.md).

# 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.

{% tabs fullWidth="true" %}
{% tab title="Basic variables" %}
*Scroll right to see all columns.*

<table><thead><tr><th width="189">Name</th><th width="151" data-type="checkbox">Mandatory</th><th width="310">Purpose</th><th width="226">Example</th></tr></thead><tbody><tr><td>Version of the PostgreSQL instance</td><td>true</td><td>Version of PostgreSQL you want to install</td><td>16.4</td></tr><tr><td>Apply OS prerequisites</td><td>true</td><td>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</td><td>true or false</td></tr><tr><td>Installation type</td><td>true</td><td>Installation using PostgreSQL source code and in-place compilation ("src") or using pre-compiled PostgreSQL binaries ("bin").<br>"bin" only available for Red Hat Enterprise Linux and Debian (SUSE Linux Enterprise Server will come later).</td><td>"src" or "bin"</td></tr><tr><td>Instance name</td><td>true</td><td>Name of the PostgreSQL instance/cluster<br>(<a href="https://www.postgresql.org/docs/current/runtime-config-logging.html#GUC-CLUSTER-NAME)%22">https://www.postgresql.org/docs/current/runtime-config-logging.html#GUC-CLUSTER-NAME</a>)</td><td>PG01</td></tr><tr><td>Instance port</td><td>true</td><td>TCP/IP port the PostgreSQL instance listens on. The port must be different for each instance/cluster (<a href="https://www.postgresql.org/docs/current/runtime-config-connection.html#GUC-PORT)%22">https://www.postgresql.org/docs/current/runtime-config-connection.html#GUC-PORT</a>)</td><td>1521</td></tr><tr><td>Log time zone</td><td>true</td><td>Time zone used for timestamps written to the instance log<br>(<a href="https://www.postgresql.org/docs/16/runtime-config-logging.html#GUC-LOG-TIMEZONE)%22">https://www.postgresql.org/docs/16/runtime-config-logging.html#GUC-LOG-TIMEZONE</a>)</td><td>Europe/Zurich</td></tr></tbody></table>
{% endtab %}

{% tab title="Advanced variables" %}
*Scroll right to see all columns.*

<table><thead><tr><th width="185">Name</th><th width="160" data-type="checkbox">Mandatory</th><th width="306">Purpose</th><th width="350">Example</th></tr></thead><tbody><tr><td>PostgreSQL user home directory</td><td>false</td><td>Home directory of the PostgreSQL OS user</td><td>/home/postgres</td></tr><tr><td>PostgreSQL extensions to install</td><td>false</td><td>List of extensions you want to install in 'template1' database of the PostgreSQL instance</td><td>pg_stat_statements, pg_prewarm, pg_trgm</td></tr><tr><td>Mount point for PostgreSQL binaries</td><td>false</td><td>Mount point where the PostgreSQL binaries will be installed (usually /u01)</td><td>/u01</td></tr><tr><td>Mount point for PostgreSQL data</td><td>false</td><td>Mount point where the PostgreSQL data will be stored (usually /u02)</td><td>/u02</td></tr><tr><td>Mount point for PostgreSQL archived WAL</td><td>false</td><td>Mount point where the PostgreSQL archived WAL will be stored (usually /u90)</td><td>/u90</td></tr><tr><td>Deployment with root privilege</td><td>false</td><td>Untick the box if the ansible user don't have root privileges on the target host(s).<br>More details <a href="/yak-user-doc/manage-components/component-types/postgresql/pre-requisites.md#requirements-for-deployment-without-root-privileges">here</a>.</td><td></td></tr><tr><td>SMTP server</td><td>false</td><td>IP or Hostname of the smtp server or relay host for pgBackRest and pg_dump notifications (DMK setting)</td><td>localhost</td></tr><tr><td>Mail from</td><td>false</td><td>Email address from which the notifications are send (DMK setting)</td><td>postgres@localhost</td></tr><tr><td>Mail to</td><td>false</td><td>Comma separated list of email addresses to which the notifications are send (DMK setting)</td><td>dba@example.com,servicedesk@example.com</td></tr><tr><td>Load Balancer type</td><td>true</td><td>Load Balancer / VIP to use.<br>Only Keepalived, Azure Load Balancer and AWS Network Load Balancer are supported for now.</td><td>AWS</td></tr></tbody></table>
{% endtab %}
{% endtabs %}