Creating PostgreSQL Configuration
- Jan Klinke
In this section, we will see how to create a PostgreSQL replication with Dbvisit StandbyMP.
1. Prerequisites
Confirm that primary and standby servers have supported OS versions as per: Operating System and Cloud Support
Confirm that Dbvisit StandbyMP was installed correctly and that you fulfill all rperequisites listed here, including the PotgreSQL specifics:
Installation Requirements | 3.3 Postgres
PostgreSQL Software needs to be installed on both the primary and standby database servers (initdb isn’t necessary for standby server). PostgreSQL Software version must be supported by Dbvisit StandbyMP as per: Database Support | 3. Postgres Database Support
You have a Primary Cluster already configured, and it is online and fully functional.
2. Creating PostgreSQL Database Configuration
Once all prerequisites are met, you can proceed with creating of new PostgreSQL Database configuration in dbvcontrol GUI. After login, click on NEW CONFIGURATION (1) and select Start with PostgreSQL (2):
On following form, you will have to select primary and standby server, provide information about primary cluster, future standby cluster port and license information:
Number | Description | Explanation |
|---|---|---|
1 | Primary Host | Choose your primary PostgreSQL host. If the host isn’t visible in the list, dbvagentmanager is either not running on that host, dbvagentmanager was incorrectly configured or the communication between primary and dbvcontrol host is blocked by firewall. |
2 | Standby Host | Choose your standby PostgreSQL host. If the host isn’t visible in the list, dbvagentmanager is either not running on that host, dbvagentmanager was incorrectly configured or the communication between standby and dbvcontrol host is blocked by firewall. |
3 | Primary PostgreSQL cluster information | Summary of your primary PostrgeSQL primary cluster and the port on which the cluster is listening |
4 | Standby PostgreSQL cluster port | Port on which the Standby PostgreSQL cluster will be listening once it is initialized by Dbvisit StandbyMP. If is possible to choose custom port. |
5 | PostgreSQL on primary host | Choose PostgreSQL binary version you want to use for replication. This is useful if you have multiple PostgreSQL installations on primary host |
6 | PostgreSQL on standby host | Choose PostgreSQL binary version you want to use for replication. This is useful if you have multiple PostgreSQL installations on standby host |
7 | Configuration Name | Choose suitable name for your PostgreSQL replciation configuration |
8 | Licence Key | Enter valid licence key |
9 | Create Configuration | Click to create configuration. Standby PostgreSQL cluster will not be created at this moment |
Once the configuration is created successfully, it will be presented like so in the dbvcontrol dashboard:
The next step is to create standby PostgreSQL cluster