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.
Ensure that the user has administrator (Windows) or root (Linux) access.
(LVM users) Ensure that data logs and the logs directory reside on the logical volume.
Set the following parameters in the
nbpgsql.conffile:PGSQL_TARGET_DIRECTORY
MASTER_SERVER_NAME
DB_PORT
CLIENT_NAME
DB_BACKUP_ID