Ransomware attackers specifically target and attempt to destroy backup systems to increase the probability of payment. Hardening your system is critical. Please ensure you have reviewed your platform security using the Security Hardening Checklist
Cohesity

COHESITY Documentation

Explore our documentation to get started, discover products & new features, access troubleshooting guides, register sources, platforms support.

Products
Data Security Alliance
Visit Cohesity.com
Demos
Support
Blogs
Developers
Partner Portals
Cohesity Community
© 2026 Cohesity, Inc. All Rights Reserved.
Terms of Use|
Privacy Policy|
Legal|
  1. Home
  3. Veritas NetBackup™ for PostgreSQL Administrator's Guide
  5. NetBackup for PostgreSQL backup and restore
  7. About PostgreSQL restore
Veritas 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 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.

Figure: NetBackup for PostgreSQL restore workflow

NetBackup for PostgreSQL restore workflow
The NetBackup for PostgreSQL restore workflow

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.

Prerequisites

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.conf file:

    • PGSQL_TARGET_DIRECTORY

    • MASTER_SERVER_NAME

    • DB_PORT

    • CLIENT_NAME

    • DB_BACKUP_ID

Feedback

Was this page helpful?
Previous

Deleting backup information from the NetBackup catalog files

Next

Performing the PostgreSQL restores

Feedback

Was this page helpful?