Configuring
Suggest editsImplementing 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
Log in to the NetBackup Administration console:
Use the credentials for the root user.
Select the hostname for the NetBackup master server you want to administer.
Create a policy for EDB Postgres Advanced Server:
Note
See the Veritas NetBackup Administrator's Guide for detailed information on policies.
Select NetBackup Management > Policies.
Select the NetBackup server. Right-click and select New Policy.
In the Add New Policy dialog box, enter the policy name and select OK.
On the Clients tab, select New.
In the Add Client dialog box, enter the NetBackup client name and select OK.
On the Attributes tab, set Policy type to DataStore.
From available values, select Policy storage.
Set any other parameters you require for your policy, and then select OK.
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:
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.
Create a writeable
<archivedir>
directory at your desired location.To turn on WAL archiving, set the required parameters in the
postgresql.conf
file:
Note
Replace <archivedir>
in the archive_command
parameter with the location of the directory created in Step 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!