Table of Contents Previous Next


4 Configuration : 4.2 Configuring a Database Server for BART Management : 4.2.2 Setting up a Replication Database User

Sets the Postgres archive_command configuration parameter when the INIT subcommand in invoked.
Creates backups when the BACKUP subcommand is invoked.
The pg_hba.conf file must minimally permit the replication database user to have access to the template1 database as shown for repuser in the following example.
For pg_basebackup only: The replication database user must also be included in the pg_hba.conf file as a replication database connection as shown by the last entry in the example if pg_basebackup is to be used for taking any backups such as for standby servers.
The replication database user must be specified with the user parameter of the BART configuration file for the database server as shown by the following:
For example, if bartuser is the BART user account, then the .pgpass file located in /home/bartuser/.pgpass must contain the following entry.
Thus, when bartuser runs BART BACKUP, the password for the replication database user, repuser, is obtained from the .pgpass file of bartuser to connect to the database server running at 192.168.2.24 on port 5444.
The .pgpass file must contain an entry for each BART managed database server and its corresponding replication database user and password.

4 Configuration : 4.2 Configuring a Database Server for BART Management : 4.2.2 Setting up a Replication Database User

Table of Contents Previous Next