Create PostgreSQL Cluster Configuration

Owned by Vijayganesh Sivaprakasam
Last updated: Aug 28, 2023
4 min read

1. Introduction

In this section, we will see how to create a PostgreSQL configuration on Dbvisit Standby MP.It is important that before you continue with this section, you have to ensure the pre-requisites are met.

The Dbvisit multiplatform agent manager is installed in both primary and standby. The control center is either installed on a third server or installed with the standby server. The agentmanager must be installed using the same user as the Postgres binary installed user in Linux, and for Windows, the installed user must have all the prerequisites met as per System Requirements page.

The PostgreSQL configuration does not differ based on the methods used for creating the DR cluster.

2. Create PostgreSQL Configuration

The steps for creating a PostgreSQL configuration are simple and straightforward. From the New Configuration tab on GUI ( 1 ), click on Start with PostgreSQL ( 2 ).

The data directory , config directory and the backup directory (If different from default) must be created on the standby server before creating the configuration. These locations can be different from the primary cluster, but its recommended to keep the same directory structure as primary to ensure uniformity across Production and DR Clusters.

Choose your Primary Cluster server. In the below case, it is centlin71.oraclekiwi.co.nz

After the primary host is chosen ( 1 ), Below are the details that are displayed along with the option to choose your Standby Host ( 5 )

  1. The source host in which the production PostgreSQL cluster is running.

  2. The port in which the production cluster is running. In this case, the port is 5432( the default port, but this can be any port, and if multiple clusters are running on the source host, all the ports on which the clusters are running will be displayed.

  3. The basic information on the cluster is displayed on the screen which included the Cluster name, Data directory, Configuration directory, the database names and sizes. In this case there are two user databases one and new.

  4. The Source PostgreSQL installation location along with the version of the cluster.

  5. Standby host, based on the number of hosts configured, a desired standby host can be chosen. The source host is not highlighted here, and the standby host must differ from the host.

  6. The Standby Cluster port number. It is recommended to keep the same port as the source, but there is an option to use a different port number.

  7. The standby cluster version. This must be the same as the primary (there can difference in the release version)

  8. The Configuration name of the Cluster pair. The name is recommended to be a distinct name.

  9. The license key must be entered for the configuration to be created.

  10. Click on create configuration to create the new Cluster configuration pair.

 

 

  1. The cluster configuration name

  2. The Primary/Source cluster is status, which is ONLINE. This shows the production cluster is up and running.

  3. The production clusters hostname

  4. The standby clusters hostname

  5. The option to start creating the DR cluster, by clicking the Set up now? option

 

Clicking on the Cluster Configuration name displays the Actions that can be performed.

  1. Setting up a DR cluster

  2. Configuration Information

  3. Start/Stop Cluster

  4. Remove the configuration

 

 

 

 

 

Â