PostgreSQL Settings

The PostgreSQL tab applies to VMs that run PostgreSQL.

To create transactionally consistent backups of a PostgreSQL VM, you must check that application-aware processing is enabled and then specify settings of WAL files processing.

Enabling Application-Aware Processing

Before configuring WAL files processing, check that application-aware processing is enabled:

1. At the Guest Processing step of the wizard, select the Enable application-aware processing check box.
2. Click Applications.
3. In the displayed list, select the PostgreSQL VM and click Edit.

To define custom settings for a VM added as a part of a VM container, you must include the VM in the list as a standalone object. To do this, click Add and choose the necessary VM. Then select the VM in the list and define the necessary settings.

4. In the Processing Settings window, on the General tab, check that Require successful processing or Try application processing, but ignore failures option is selected in the Applications area.

Specifying WAL Files Settings

To define how Veeam Backup & Replication will process WAL files on this VM, do the following:

1. In the Processing Settings window, click the PostgreSQL tab.
2. From the Specify PostgreSQL account with superuser privileges drop-down list, select a user account that Veeam Backup & Replication will use to connect to the PostgreSQL instance. The account must have privileges described in section Permissions. You can select Use guest credentials from the list of user accounts. In this case, Veeam Backup & Replication will use the account specified at the Guest Processing step of the wizard to access the VM guest OS and connect to the PostgreSQL instance.

If you have not set up credentials beforehand, click the Manage accounts link or click the Add button to add credentials. Note that if you select the System user without password file (peer) option in the The specified user is area, you can add a user account without specifying a password.

3. In the The specified user is section, specify how the user selected in the Specify PostgreSQL account with superuser privileges drop-down list will authenticate against the PostgreSQL instance:

• Select Database user with password if the account is a PostgreSQL account, and you entered the password for this account in the Credentials Manager.
• Select Database user with password file (.pgpass) if the password for the account is defined in the .pgpass configuration file on the PostgreSQL server. For more information about the password file, see PostgreSQL documentation.
• Select System user without password file (peer) if you want Veeam Backup & Replication to use the peer authentication method. In this case, Veeam Backup & Replication will apply the OS account as the PostgreSQL account.