Configure PostgreSQL instance
You can configure PostgreSQL backup for user to perform backup and recovery by configuring the following environment variables:
Note:
Add these environment variables to the user for which NetBackup backup is to be run.
(optional) path - Add PostgreSQL bin path to this environment variable for running queries and connecting to databases.
(optional) LIB_PQ_PATH - For Windows set this environment variable to provide the location of
libpq.dlllibrary. For Linux set this environment variable to provide the location oflibpq.solibrary.(optional) PG_PRO_BACKUP_DUMP_DIRECTORY - Set this environment variable as temporary backup dump directory for non streaming backup. For example, On Linux computer, user can set this environment variable to required location using the command:
echo "export PG_PRO_BACKUP_DUMP_DIRECTORY=/home/custom_dump_dir_location/" > > ~/.bashrc
For Windows, user can create new environment variable and add path of folder location as:PG_PRO_BACKUP_DUMP_DIRECTORY=C:\custom_dump_dir_location
(optional) LVM SNAPSHOT_SIZE - Set this environment variable to provide the snapshot size for LVM backup for Linux operating system only. You can set environment variable of LVM Snapshot size to 500 MB using the command:echo "export LVM_SNAPSHOT_SIZE=500MB" >> ~/.bashrc
Note:
The default snapshot size is set to 500MB.
(optional) DELETE_WAL_LOGS - Set this environment variable to delete
Wallogs after backup is done. The value can be set to 0 or 1.PGSQL_COMPRESSION_VALUE - Level of compression which is given to the compression algorithm. Value can be between 0 and 9. Zero being lowest and nine being highest compression ratio.
(Optional) PG_BACKREST_MAX_PROCESSES_<port> - Set this environment variable to specify the number of threads to use for copying multiple data files concurrently while performing backup and recovery with pgbackrest utility