‘Configuring the Integration’

ImplementingVeritasNetBackupsolutionforbackup/restoreofPostgreSQLdatabasesrequiresthefollowingcomponents:

  • EDB Postgres Advanced Server.

  • Veritas NetBackup Server.

  • Veritas NetBackup Client.

  • Veritas NetBackup Agent for PostgreSQL.

Prerequisites

  • A running EDB Postgres Advanced Server.

  • A running Veritas NetBackup Server.

  • Veritas NetBackup Client installed on the EDB Postgres Advanced Server host.

  • Veritas NetBackup PostgreSQL Agent installed on the EDB Postgres Advanced Server host.

Configuring Veritas NetBackup for PostgreSQL consists of configuring the following components:

  • Veritas NetBackup Agent for PostgreSQL.

  • PostgreSQL server.

The steps below show an example of how to configure Veritas NetBackup for PostgreSQL for EDB Postgres Advanced Server.

Configuring Veritas NetBackup for PostgreSQL

  1. Log on to the NetBackup Administration Console:

  1. Use the credentials for the root user

  2. Select the hostname for the NetBackup Master Server you want to administer

  1. Create a policy for EDB Postgres Advanced Server:

Note

Refer to the Veritas NetBackup Administrator’s Guide for detailed information on policies.

  1. Click on NetBackupManagement>Policies , select the NetBackup server

  2. Right mouse click and select NewPolicy

  1. Enter the policy name in the AddNewPolicy dialog box and click OK

  1. Select the Clients tab e. Click on New f. Enter the NetBackup client name in the AddClient dialog box, and click OK

  1. Select the Attributes tab h. Select DataStore for Policytype

  2. Select Policystorage from available values

  3. Set any other parameters you require for your policy and then click OK

  1. On the NetBackup Client, update the agent configuration file /usr/NBPostgreSQLAgent/nbpgsql.conf to set the necessary parameters to make the agent work successfully with EDB Postgres Advanced Server: edb_notranlate_0

Note

Value of PGSQL_LIB_INSTALL_PATH will be dependent on the version of EDB Postgres Advanced Server installed. Values of MASTER_SERVER_NAME and POLICY_NAME parameters must match the names of your NetBackup Master Server and DataStore Policy respectively.

In the sample configuration file above, the values for DB_USER , DB_PORT , DB_INSTANCE_NAME , and PGSQL_LIB_INSTALL_PATH have been substituted for EDB Postgres Advanced Server as the default values are for Postgres. Refer to the Veritas NetBackup for PostgreSQL Administrator’s Guide for detailed description of the parameters.

Configuring EDB Postgres Advanced Server

Set up WAL archiving on the EDB Postgres Advanced Server server by using the steps below. WAL archiving prepares Postgresql/EDB Postgres Advanced Server database servers for backup/recovery operations and is a precondition for any backup/recovery tool to work with the database server.

  1. Create a writeable <archivedir> directory at your desired location.

  2. Set the required parameters in the postgresql.conf file to turn on WAL archiving: edb_notranlate_1

Note

Replace <archivedir> in the archive_command parameter with the location of the directory created in Step 1.

  1. Restart the PostgreSQL server.

Refer to the Veritas NetBackup for PostgreSQL Administrator’s Guide for detailed information on how to configure EDB Postgres Advanced Server for Veritas NetBackup Agent for PostgreSQL.