Table of Contents Previous Next


1 Quickstart : 1.3 Configuring the Database Server

a.
In the SSH server daemon configuration file /etc/ssh/sshd_config, check that the following parameter is set to yes and is not commented.
b.
Reload the configuration file using the service sshd reload, service sshd stop, service sshd start, or service sshd restart.
Note: For any SSH or SCP errors, examine the log file /var/log/secure
1.
Choose a database user to serve as the replication database user (superuser) for each Postgres database server to be managed by BART.
2.
Modify the pg_hba.conf file to allow the replication database user to access the template1 database. Include the replication database user in the pg_hba.conf file as a replication database connection if pg_basebackup is to be used for taking any backups.
To enable WAL archiving, set the following parameters in the postgresql.conf for the database server for which BART is to perform backup:
wal_level to replica for Postgres versions.
archive_command to copy the WAL files to the BART backup catalog.
max_wal_senders to a value high enough to leave at least one session available for the backup. If the xlog_method=stream parameter setting is to be used by this server, the max_wal_senders setting must account for an additional session for transaction log streaming.
Note: Run the INIT subcommand with the -o option to override any existing archive_command setting in the postgresql.conf or the postgresql.auto.conf file.
1.
After verifying that the full path of the BART backup catalog has been created, restart the database server to initiate WAL archiving.
Use the CHECK-CONFIG subcommand with the –s option to verify the parameter settings in the database server configuration for which the -s option is specified.
In addition, the following postgresql.conf parameters for the database server must be properly set and activated for certain processes:
The cluster_owner parameter must be set to the user account owning the database cluster directory.
The pg_hba.conf file must contain a replication entry for the database superuser specified by the BART user parameter.
The archive_mode parameter in the postgresql.conf file must be enabled.
The archive_command parameter in the postgresql.auto.conf or the postgresql.conf file must be set.
The allow_incremental_backups parameter in the BART configuration file must be enabled for database servers for which incremental backups are to be taken.

1 Quickstart : 1.3 Configuring the Database Server

Table of Contents Previous Next