Introduction, PostgreSQL Installation, and Configuration Creation
- Vijayganesh Sivaprakasam
- Alex Masharov
This is the documentation for a quick guide on installing, configuring, and managing the PostgreSQL DR cluster using Dbvisit. The initial version of Postgres will be available only on Linux platforms, and then a windows version will be made available. The support Postgres versions are 10,11,12,13 & 14.
The supported platforms are Redhat Linux, Oracle Linux, CentOS, Ubuntu and Rocky Linux (6,7 & 8).
The primary and standby cluster must be of the same version, but the release number can be different
Installation
The Dbvisit Installation process for Postgres is exactly the same as Linux installations for Oracle and SQL Server. Below is the Standby MP user guide link that discusses this in detail.
Installing Standby Multiplatform | Installing Standby Multiplatform on Unix
By default, the installation directory is /usr/dbvisit.
The installation must be performed with the same user as postgres binary owner. Below is the screenshot of the processes running after installation.
Primary Server agentmanager installation:
-bash-4.2$ ps -ef |grep dbv
postgres 1094 1 0 Mar22 ? 00:01:18 /usr/dbvisit/standbymp/bin/dbvagentmanager service run
-bash-4.2$ Standby Server on which both agentmanager and control center is installed.
-bash-4.2$ ps -ef |grep dbv
postgres 6359 1 0 Mar22 ? 00:02:55 /usr/dbvisit/standbymp/bin/dbvagentmanager service run
postgres 6432 1 0 Mar22 ? 00:04:44 /usr/dbvisit/standbymp/bin/dbvcontrol service run
-bash-4.2$ Create Configuration
To create a PostgreSQL configuration, the binaries must be installed on the standby server. The necessary folder for the data directory must be created, and the custom backup and wal file locations must also be created.
To create a new configuration from the GUI click on 'Start with PostgreSQL”
2. Select the primary host from the drop down menu, this should automatically recognise the port on which the cluster is running.
( 1 ) Port on which the cluster is running. If multiple clusters are running on the same server, this would list all the cluster ports through which the cluster can be discovered.
( 2 ) Cluster information on the databases and the tablespaces. Along with Data and Configuration directory.
( 3 ) Binary directory along with the version of the cluster used.
( 1 ) Standby host chosen from the dropbox (Cannot be same as primary)
( 2 ) The port on which the standby cluster will be created. This can be different from the primary cluster port.
( 3 ) The port is checked for any existing cluster running on the server
( 4 ) Version of the standby cluster
( 5 ) Configuration name.
( 6 ) License key. The license key is must to create the configuration.
After entering the license, click on “Create Configuration” to create a new configuration
( 1 ) Dbvisit PostgreSQL configuration name.
( 2 ) Status of the primary cluster
( 3 ) There is no standby cluster available and its ready to set up a new DR PostgreSQL cluster.