Performing PostgreSQL backups

This topic lists the prerequisites for the backup, describes the procedure to run a backup, and the information to schedule the backup from NetBackup.

Prerequisites

Before you run the backup, ensure that you meet the following prerequisites:

Ensure that versions of the PostgreSQL agent and NetBackup are same. If you upgrade NetBackup to newer version, then you must upgrade the agent version also.
Ensure that the user has administrator (Windows) or root (Linux) access.
(Windows) Set the NetBackup\bin directory in the environment variable.
For example, Path =C:\Program Files\Veritas\Netbackup\bin
(Windows) Set the PostgreSQL\bin directory in user environment variable.
For example, Path=C:\Program Files\PostgreSQL\bin
(Linux) Symbolic link: If a symbolic link does not exists, create the symbolic link libpq.so and ensure that it points to the valid libpq .so.<n>, where n is the PostgreSQL library version.
For more information, See Post-installation requirements for NetBackup for PostgreSQL Agent.
Set the following parameters in the nbpgsql.conf file:
- DB_USER
- DB_PORT
- MASTER_SERVER_NAME
- POLICY_NAME
- SCHEDULE_NAME
- (Linux) PGSQL_LIB_INSTALL_PATH
- (Linux) SNAPSHOT_SIZE
Create the archivedir directory and then set the following parameters in the postgresql.conf file:
- wal_level = archive
- archive_mode = on
- archive_timeout =0
- statement_timeout=0
  Note:
  Ensure that you add the time in milliseconds. The recommended time is 30000 milliseconds (30 seconds).
Mention the following changes for archive_command
- (Windows)'copy ' "%p" "C:\\archivedir\\%f"'
- (Linux) test ! -f <archive_path>/%f && cp %p <archive_path>/%f
(Linux) After creating the archivedir directory, change the group and ownership to PostgreSQL user.
Restart the PostgreSQL services.
Configure PostgreSQL backups with DataStore policies.
For more information, See Configuring PostgreSQL backups with DataStore policies.
Verify the installation prerequisites and the post-installation requirements.
For more information, See Installing prerequisites for NetBackup for PostgreSQL Agent.
For more information, See Post-installation requirements for NetBackup for PostgreSQL Agent.

To run the backup

Run the following command:
nbpgsql -o backup
-S master_server
-P policy_name
-s schedule_name
(Linux)-z snapshot_size
(Linux)-l postgresql_library_path
[-portnum db_port]
[-u dbuser]
(Optional) Type the database password, when the command line prompts for a password . NetBackup connects to the database and initiates the backup.

Note:

Ensure that the PostgreSQL agent and NetBackup are of same version for successful backup and restore operations.

Scheduling PostgreSQL backups from NetBackup

You can schedule the PostgreSQL backups from the NetBackup Administration Console using the DataStore policy to call a backup script.

For more information, see https://www.veritas.com/support/en_US/article.100041371

Performing PostgreSQL backups

Feedback

Feedback