Configuring Veritas NetBackup for PostgreSQL

Implementing Veritas NetBackup solution for backup/restore of PostgreSQL databases requires the following components:

• 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:

   a. Use the credentials for the root user

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

2. Create a policy for EDB Postgres Advanced Server:

   Note

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

   a. Click on NetBackup Management > Policies, select the NetBackup server

   b. Right mouse click and select New Policy

   

   c. Enter the policy name in the Add New Policy dialog box and click OK

   

   d. Select the Clients tab

   e. Click on New

   f. Enter the NetBackup client name in the Add Client dialog box, and click OK

   

   g. Select the Attributes tab

   h. Select DataStore for Policy type

   i. Select Policy storage from available values

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

   

3. 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:

   Toggle WrapCopy

   DB_USER= enterprisedb
   DB_PORT=5444
   DB_INSTANCE_NAME=edb
   PGSQL_LIB_INSTALL_PATH= /usr/edb/as13/lib
   MASTER_SERVER_NAME=<netbackup-master-server>
   POLICY_NAME=<datastore-policy>
   SCHEDULE_NAME= Default-Application-Backup
   SNAPSHOT_SIZE=4MB

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:

   Toggle WrapCopy

   wal_level = archive
   archive_mode = on
   archive_timeout = 0
   statement_timeout = 0
   archive_command = test ! -f <archivedir>/%f && cp %p <archivedir>/%f

3. 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.

• On this page
• Prerequisites
• Configuring Veritas NetBackup for PostgreSQL
• Configuring EDB Postgres Advanced Server