NetBackup™ for PostgreSQL Administrator's Guide

Last Published:
Product(s): NetBackup (10.1)

About NetBackup for PostgreSQL

NetBackup for PostgreSQL Agent extends the capabilities of NetBackup to include backup and restore of the PostgreSQL databases. The agent supports the PostgreSQL version 9 and later.

The agent also supports to:

  • Validate the backup.

  • Query a backup and restore.

  • Delete the backup information from the catalog files.

  • Redirect restores.

NetBackup for PostgreSQL is available with NetBackup client.

Note:

Ensure that all the NetBackup hosts are of the same NetBackup version for successful backup and restore operations.

The NetBackup for PostgreSQL workflow

The agent communicates with the PostgreSQL database to create a snapshot. The Volume Shadow Copy Services (VSS) for Windows or Logical Volume Manager (LVM) for Linux, takes a snapshot of the PostgreSQL database.

The agent then interacts with the NetBackup XBSA interface to update the server name, policy, and schedule type information. The NetBackup primary server connects to the NetBackup client to backup or retrieve the data that you want to protect.

The agent mounts the snapshot, copies the file, and sends it to the NetBackup XBSA interface. The NetBackup XBSA interface writes this data to the mounted media or disk storage that is managed by the NetBackup media server.

Table: NetBackup for PostgreSQL configuration files lists the configuration files. These files contain the parameters that you must specify for the respective operations.

Table: NetBackup for PostgreSQL configuration files

Component

Description

nbpgsql.conf file

The nbpgsql.conf file contains the parameters that you must specify before you run the nbpgsql operations.

For more information,

recovery.conf file

The recovery.conf file contains the parameters that you must set for PostgreSQL to perform an archive recovery. You must set the parameters again for the subsequent recovery that you must perform.

For more information, See Recovering the restores.

postgresql.conf file

The postgresql.conf file contains the parameters that you must set to archive the Write-Ahead Logs.

For more information,See About PostgreSQL backups.

pgpass.conf file

The pgpass.conf file contains the password to connect to the database for Windows.

For more information, See Authenticating the PostgreSQL environment password .

.pgpass file

The .pgpass file contains the password to connect to the PostgreSQL database for Linux operating systems.

For more information, See Authenticating the PostgreSQL environment password .

Note:

You must set the parameters in the nbpgsql.conf file before you run the operations or provide them on the nbpgsql command line, where command line parameters take precedence.