| Table of Contents |
|---|
1. Introduction
This page will show us how to create a cascade configuration using PostgreSQL. This page will have the below topic covered.
...
The configuration name of the cascade standby cluster.
The source hosts data directory.
the cascade standby hosts data directory.
The important point is that we are creating the cascade configuration and the replication mode must be same as the source configuration.
As per requirement, the cascade configuration must be created as Hot Standby.
The method used for creating the cluster is WAL Streaming as the source configuration (PG-5435-13)
The connection is successful in creating
the replication for cascade configuration.
Enable the observer to monitor the configuration.
Click Start to start creating the DR cluster.
After successfully creating the DR cluster. The status of the original cluster ( 1 ) and the cascade standby cluster ( 2 ). Any transaction happening in the source host (centlin71.oraclekiwi.co.nz) will be first applied to the standby host (centlin72.oraclekiwi.co.nz), and then the changes are applied to the cascade standby cluster (nzel81.oraclekiwi.co.nz). The status of both the standby and the cascade standby are now Synced and it is In Sync status.
4. Graceful Switchover
The switchover process can only be run for the original configuration (PG-5432-13) and not for the cascaded configuration (PG-5435-13-CAS). Even after the switchover is completed, the sync process will continue with the new configuration setting to the cascade configuration standby server (nzel81.oraclekiwi.co.nz). The configuration instead of being a cascaded configuration (A-->B-->C) has become a configuration with 2 standby clusters with the same source host (A -->B A-->C).
...
Now, a switchover can be performed for the cascade configuration(PG-5435-13-CAS), making the standby host (nzel81.oraclekiwi.co.nz) the primary host by doing this. The original configuration (PG-5435-13) becomes the cascade configuration.
...