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.
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\bindirectory in the environment variable.For example,
Path =C:\Program Files\Veritas\Netbackup\bin(Windows) Set the
PostgreSQL\bindirectory 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.soand ensure that it points to the validlibpq .so.<n>, wherenis the PostgreSQL library version.
#ln -s /<pgsql_lib_install_path>/libpq.so.<n> libpq.soFor more information, See Post-installation requirements for NetBackup for PostgreSQL Agent.
Set the following parameters in the
nbpgsql.conffile:DB_USER
DB_PORT
MASTER_SERVER_NAME
POLICY_NAME
SCHEDULE_NAME
(Linux) PGSQL_LIB_INSTALL_PATH
(Linux) SNAPSHOT_SIZE
Create the
archivedirdirectory and then set the following parameters in thepostgresql.conffile: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
archivedirdirectory, change the group and ownership to PostgreSQL user.Restart the PostgreSQL services.
Configure PostgreSQL backups with 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]
(Linux)[-b backup_type]
- (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.
You can schedule the PostgreSQL backups from the using the DataStore policy to call a backup script.
For more information, see https://www.veritas.com/support/en_US/article.100041371