Specifying PostgreSQL Processing Settings

You can enable PostgreSQL processing settings in the properties of a volume-level backup job configured in Veeam Agent for Linux.

To enable PostgreSQL processing settings for the backup job, use the following command:

veeamconfig aap set postgres --jobid <job_id> <postgres_options>

or

veeamconfig aap set postgres --jobname <job_name> <postgres_options>

where:

  • <job_id> — ID of the backup job for which you want to enable PostgreSQL processing settings. You should look up the job ID in advance, before configuring PostgreSQL processing settings, for example, with the veeamconfig job list command. To learn more, see Viewing List of Backup Jobs.
  • <job_name> — name of the backup job for which you want to enable PostgreSQL processing settings.

 

Specifying PostgreSQL Processing Settings TIP

To view IDs or names of all existent backup jobs, you can press the [Tab] key right after you type the --jobid or --jobname option.

PostgreSQL Processing Settings

You can specify the following PostgreSQL processing settings for the backup job:

Option

Description and values

--tryprocess

Defines that Veeam Agent must continue the backup process if errors occur when processing the PostgreSQL database system. If you do not specify this option, Veeam Agent will stop the backup process if an error occurs when processing the PostgreSQL database system.

--usrpgdb

Name of the PostgreSQL account.

If you use a password file to connect to the PostgreSQL database system, the --usrpgdb option allows to select the user from the password file.

You do not need this option if you want to use a Veeam Agent machine OS account to connect to the PostgreSQL database system. Instead, specify the OS account with the --usrpgos option.

--password

Password of the PostgreSQL account.  

If you do not specify this option, Veeam Agent will prompt to enter the password. If you do not specify the password in prompt, Veeam Agent uses a password file to connect to the PostgreSQL database system. To learn more about password file configuration, see Preparing Password File for PostgreSQL Processing.

Keep in mind, if you specify the password using the --password option, password is stored in terminal in plain text.

--usrpgos

Name of the OS account. Veeam Agent will use the name to connect to the PostgreSQL database system using the peer authentication method. In the peer authentication method, Veeam Agent uses the OS account as the PostgreSQL database user name. With this option selected, you must specify OS account only. To learn more about peer authentication, see PostgreSQL documentation.

You do not need this option if you want to use a PostgreSQL account to connect to the database system. Instead, specify the PostgreSQL account with the --usrpgdb option.

For example:

user@srv01:~$ veeamconfig aap set postgres --jobid 29bc2e1a-e35c-4efb-8d37-b7177b8ea75 --tryprocess --usrpgdb postgres --password P@ssw0rd