NetBackup™ for PostgreSQL Administrator's Guide

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 exist on the specified client. When you do not specify -C, it defaults to NetBackup primary server.

Figure: NetBackup for PostgreSQL restore workflow

After you specify the parameters, the agent reads the command line arguments.

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.