Get Postgres Tips and Tricks
Subscribe to get advanced Postgres how-tos.
![]() |
![]() |
![]() |
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:
5 Sample BART System with Local and Remote Database Servers : 5.3 Configuring a Replication Database User
![]() |
![]() |
![]() |