Table of Contents Previous Next



The replication database user for each database server is specified by the user parameter in the BART configuration file as shown by the following:
To allow the required no prompt for password access to each database server when the BART user account initiates the backup, the .pgpass file contains the following entries. This file is for BART user account, enterprisedb, located in its home directory, /opt/PostgresPlus/9.5AS/.pgpass.
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:


Table of Contents Previous Next