Table of Contents Previous Next


5 Sample BART System with Local and Remote Database Servers : 5.3 Configuring a Replication Database User

The replication database user for each database server is specified by the user parameter in the BART configuration file as shown by the following:
Add entries to the .pgpass file on each server to allow the BART user account to initiate a backup without being prompted for credentials. The .pgpass file is located in /opt/PostgresPlus/9.5AS/.pgpass.
For more information about using a .pgpass file, please see the PostgreSQL documentation at:
While connected to MKTG on 192.168.2.24, the following CREATE ROLE command is given to create the replication database superuser:
The pg_hba.conf file for the local Advanced Server, ACCTG is set as follows:
The pg_hba.conf file for the remote Advanced Server, MKTG is set as follows:
The pg_hba.conf file for the remote PostgreSQL server, HR is set as follows:

5 Sample BART System with Local and Remote Database Servers : 5.3 Configuring a Replication Database User

Table of Contents Previous Next