Configuring

Suggest edits

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 example shows how to configure Veritas NetBackup for PostgreSQL for EDB Postgres Advanced Server.

Configuring Veritas NetBackup for PostgreSQL

  1. Log in 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.

      NetBackup Admin Console

  2. Create a policy for EDB Postgres Advanced Server:

    Note

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

    1. Select NetBackup Management > Policies.

    2. Select the NetBackup server. Right-click and select New Policy.

      New Policy

    3. In the Add New Policy dialog box, enter the policy name and select OK.

      Adding a Policy

    4. On the Clients tab, select New.

    5. In the Add Client dialog box, enter the NetBackup client name and select OK.

      Adding a Policy

    6. On the Attributes tab, set Policy type to DataStore.

    7. From available values, select Policy storage.

    8. Set any other parameters you require for your policy, and then select OK.

      Finish Adding a Policy

  3. On the NetBackup client, update the agent configuration file /usr/NBPostgreSQLAgent/nbpgsql.conf. Set the necessary parameters to make the agent work successfully with EDB Postgres Advanced Server:

    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
Note

The value of PGSQL_LIB_INSTALL_PATH depends on the version of EDB Postgres Advanced Server installed. Values of the MASTER_SERVER_NAME and POLICY_NAME parameters must match the names of your NetBackup master server and datastore policy, respectively.

The sample configuration file shows values for DB_USER, DB_PORT, DB_INSTANCE_NAME, and PGSQL_LIB_INSTALL_PATH set for EDB Postgres Advanced Server. The default values are for Postgres. See the Veritas NetBackup for PostgreSQL Administrator's Guide for detailed descriptions of the parameters.

Configuring EDB Postgres Advanced Server

Set up WAL archiving on the EDB Postgres Advanced Server server. 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. To turn on WAL archiving, set the required parameters in the postgresql.conf file:

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

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

  1. Restart the PostgreSQL server.

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

Could this page be better? Report a problem or suggest an addition!