Adding PostgreSQL Database Server for Backup

Adding PostgreSQL Database Server for Backup

PSQL Server can be backed up using the BDRSuite Backup Server. You can simply add the source to the BDRSuite Backup Server and configure backups. Navigate to Data Sources tab and choose Add PostgreSQL Database Server.
When a PostgreSQL Database Server is added to the BDRSuite Backup server, a BDRSuite Backup Agent (BBA) is automatically or manually  installed in the target machine.

Procedure to add PostgreSQL Database Server

PostgreSQL Database Server has to be added before you begin configuring the backup schedule. In the Data Sources tab choose ‘Add PostgreSQL database Server. You will be taken to a page where you will see a message stating ‘No host added’ if you adding host for the first time.
Click on ‘Add PostgreSQL Database Server‘ and there are two methods for both Windows & Linux, provided on the opening page for adding which are as follows;
  1. Manual Agent Installation
  2. Automatic Agent Installation

Manual Agent Installation

Step 1: Download Backup Agent

Step 2: Backup Agent Installation on Individual Hosts

Run Backup Agent setup file on the target host and follow the on-screen instructions to proceed with the installation.
During the installation, you will be prompted to enter the following information:
Display Name: Enter a name to identify the host in the backup server.
Backup Server DNS Name/IP Address: Enter the BDRSuite Backup Server DNS Name/IP Address to register this host with the backup server.
Choose Backup Component: Select the option ‘PostgreSQL Backup’.
PostgreSQL Backup: Credentials & Database Path: Specify the credential used to authenticate PostgreSQL database and the file path to the MySQL executables.
Complete the installation process by providing the necessary information.
Once the installation is successful, the agent will automatically establish connection and register the host with the backup server.
To verify the installation and connection, go to the Data Sources menu on the backup server. You will see the host details, including Hostname/IP address and connection status.

Bulk Installation of Backup Agent

Download backup agent and install it on multiple backup hosts (where the PostgreSQL Database runs) simultaneously using the command below through any third party tool.
A. Windows
msiexec /i BDRSuite_Delegation_Service_7_0_0_1_U1_.msi /qn BACKUPSERVERINFO=”Enter Backup Server IP Address/DNS Name” PSQLBACKUPENABLED=”1″ PSQLUSERNAME=”Enter PostgreSQL Database Username” PSQLPASSWORD=”Enter PostgreSQL Database Password” PSQLPORT=”Enter PostgreSQL Port” PSQLEXEPATH=”Enter PostgreSQL Server Executable Path” PSQLDUMPEXEPATH=”Enter PostgreSQL Server Dump Executable Path”
B. Linux
bash BDRSuite_Delegation_Service_7_0_0_1_U1_RH.bin –BACKUPSERVERINFO “Enter Backup Server IP Address/DNS Name” –PSQLBACKUPENABLED “1” –PSQLUSERNAME “Enter PostgreSQL Database Username” –PSQLPASSWORD “Enter PostgreSQL Database Password” –PSQLPORT “Enter PostgreSQL Port” –PSQLEXEPATH “Enter PostgreSQL Server Executable Path” –PSQLDUMPEXEPATH “Enter PostgreSQL Server Dump Executable Path”

Automatic Agent Installation

This option allows you to add each host by entering their IP address and credentials.  This will automatically install Backup Agent on the target host
Add PostgreSQL Database Server by providing ‘Hostname/IP Address and its login credentials.
Notes
Note: You can add as many PostgreSQL Servers into the BDRSuite Backup Server whenever required 
 Display Name
Specify a name for the host to identify it on the BDRSuite Backup Server. This name will be used to distinguish the hosts with the same IP Address.
IP Address/DNS Name
Enter the hostname or IP address of the hostname for which you have to proceed with the backup
The Hostname can be added using FQDN(Fully qualified domain name) ie., machine_name.domain_name. You can connect your host with BDRSuite Backup Server through any of the following combinations in the Hostname/IP Address section:
  1. Hostname – Enter the Hostname alone
  2. Hostname@Domain name – Enter the hostname followed by @ and domain name
  3. Domain name/Hostname – Enter the domain name followed backslash (/) and the hostname
  4. 192.xxx.xxx.xxx – Enter the IP address
Notes
Note: If you have provided an invalid Hostname/IP address, the following alert message will be displayed “Unable to connect the PostgreSQL Server. Please check network connection settings”
Credentials
You can add new PostgreSQL credentials or select the existing credentials.
User Name: Enter the username of the specific PostgreSQL Host
Password: The password of the PostgreSQL Host or IP Address
PostgreSQL Port [Default]: BDRSuite Backup Server uses the PostgreSQL Server default port – 5432. If you have changed it then enter the custom port.
Enter PostgreSQLExecutable Path: Enter the file path to the PostgreSQL Server executable file.
Enter PostgreSQL Dump Executable Path: 
  1. Enter the file path to the PostgreSQL Dump executable file.
  2. The path is to temporarily dump backup data in the database server before initiating the backup. You can customize the dump location for each backup job which can be done during the backup job configuration.
  3. Ensure that your storage has ample space allocated for the dump, in accordance to the size of the data intended for backup. Subsequent to the completion of the backup, the dump will be removed.
PostgreSQL Database Credentials: You can select the credentials that you used to authenticate PostgreSQL Database. You can add new PostgreSQL Database credentials or select the existing credentials.
Credential Display Name: Enter a name to identify the added credential.
User Name: Enter the username of the specific host.
Password: The password of the host or IP Address.
After entering the necessary PostgreSQL Host details, select the ‘Save’ option to initiate a pop-up prompting confirmation. Proceed by clicking on ‘Confirm,’ and the PostgreSQL Host will be successfully added to the BDRSuite Backup Server.
Edit: You can make changes to all the added details of the PostgreSQL Host using this ‘Edit’ option. The Display Name/DNS Name, the PostgreSQL Host credentials, the PostgreSQL Port, PostgreSQL Executable path, the PostgreSQL Dump path/location and the PostgreSQL Database Credentials can be modified.
Delete: If you want to remove a particular PostgreSQL Host, click the Delete option. A pop-up window with the message “Are you sure, you want to delete the selected server or host?” will appear. Click Yes, Delete.
Rescan: Executing the rescan option allows you to establish a successful connection between the BDRSuite Backup Server and the PostgreSQL Host, in case of any interruption that caused the connection failure.
Report: Click on the ‘Reports’ icon to view the Machine Name, Version, Installed Time, Status, Remarks. Further, expand it to view the installation start and end time.
Notes
Note: To obtain a stage-wise report of the agent installation, you can monitor the process in real-time. Under the ‘Status’ tab, you’ll find a ‘Progress’ icon and clicking on this icon will show you the stage-wise details, providing insights into the ongoing installation procedure.

    • Related Articles

    • Configuring PostgreSQL Database Backups

      Step 1: Adding Basic Job Details Enter the following details; Backup Job Name: Provide any proper name for your backup job. Backup Repository: Select the backup repository type. You can choose either Block Storage or Object Storage. Repository Name: ...

    • Adding MySQL Database Server for Backup

      MySQL Server can be backed up using the BDRSuite Backup Server. You can simply add the source to the BDRSuite Backup Server and configure backups. Navigate to Data Sources tab and choose Add MySQL Database Server. When a MySQL Database Server is ...

    • PostgreSQL Backup and Recovery

      PostgreSQL Backup - Overview BDRSuite provides comprehensive backups for PostgreSQL databases, offering granular-level recovery options. With flexible and instant recovery features, BDRSuite ensures seamless data restoration and business continuity ...

    • Steps to Rebuild BDRSuite Backup Server running v5.3.0 and above (PostgreSQL Database)

      KB ID: 115900 Challenge A hardware failure or system crash on the BDRSuite Backup Server machine can result in the loss of both the BDRSuite application and its backend database (PostgreSQL server). Solution In case of backup server failure/crash, If ...

    • Prerequisites for Automatically Adding Database (Microsoft SQL/MySQL/PostgreSQL) Servers in Windows and Linux Environments

      KB ID: 115214 Supported Environments Application Supported version Microsoft SQL Server Microsoft SQL Server 2022 - CU7, Microsoft SQL Server 2019 - CU22, Microsoft SQL Server 2017 - CU31, Microsoft SQL Server 2016 (SP3), Microsoft SQL Server 2014 ...