Veritas NetBackup™ for PostgreSQL Administrator's Guide
- Introduction to NetBackup for PostgreSQL
- Installing the NetBackup for PostgreSQL Agent
- Planning the installation of NetBackup for PostgreSQL Agent
- Verifying the operating systems and platforms
- Installing prerequisites for NetBackup for PostgreSQL Agent
- Post-installation requirements for NetBackup for PostgreSQL Agent
- Describing the NetBackup for PostgreSQL Agent package
- Installing the NetBackup for PostgreSQL Agent
- Authenticating the password
- Uninstalling the NetBackup for PostgreSQL Agent
- Configuring NetBackup for PostgreSQL
- NetBackup for PostgreSQL backup and restore
- About PostgreSQL backups
- Performing PostgreSQL backups
- Validating the PostgreSQL backups
- Querying the PostgreSQL backups
- Deleting backup information from the NetBackup catalog files
- About PostgreSQL restore
- Performing the PostgreSQL restores
- Redirected restores
- Recovering the restores
- Disaster recovery
- Troubleshooting for PostgreSQL
- Appendix A. NetBackup for PostgreSQL commands and conventions
- Appendix B. NetBackup for PostgreSQL commands
About PostgreSQL restore
The nbpgsql -o restore command for restore initiates the restore operation using -S and-t as the required parameters. The parameters -id and -C are optional parameters.
The parameter -id restores the backup using the specified backup image name. The parameter -C lists all the backups that exists on the specified client. When you do not specify -C, it defaults to NetBackup master server.
Note:
Ensure that the PostgreSQL agent and NetBackup are of same version for successful backup and restore operations.
After you specify the parameters, the agent reads the command line arguments and parses the nbpgsql.conf configuration file. The agent then interacts with the NetBackup XBSA interface to retrieve the backup. using the specified parameters.
The NetBackup XBSA interface reads the progress files to receive the PostgreSQL backup files to restore them to the target directory.
The command prompt indicates the successful completion status of the restore. The Activity Monitor displays the status for the restore job.
In Linux operating systems, after a successful restore, the owner and group of the restored data defaults to postgres. You must change the ownership to PostgreSQL user and modify the settings according to your environment.
In Linux operating system, if the data directory contains symbolic link, the backup does not retain the link information. The symbolic link gets backed up as a normal data directory and is restored as a normal directory. To restore the link, you must reconfigure the symbolic link.
Note:
Ensure that the target directory is valid and empty.
Before you run a restore, 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.
(LVM users) Ensure that data logs and the logs directory reside on logical volumes.
Set the following parameters in the
nbpgsql.conffile:PGSQL_TARGET_DIRECTORY
MASTER_SERVER_NAME
DB_PORT
CLIENT_NAME
DB_BACKUP_ID