| Table of Contents |
|---|
1. Introduction
The graceful switchover is a zero data loss process for role reversal between the primary and standby clusters. At the end of this process, the standby and primary clusters change roles, and the standby cluster becomes the new primary, and the primary cluster becomes the new standby. Even though this process involves a little downtime, but is seamless and does not require any manual intervention.
...
The archiving mode configuration is In Sync.
The message indicates that the configuration is ready for switchover.
User scripts that can be executed post the switchover process on new primary and standby.
Click Start to start the switchover process.
...
The configuration is In Sync with the WAL Archiving method in the reverse direction.
The observer is enabled once the switchover is completed and is now monitored.
The new primary server and Cluster status show ONLINE on port 5432.
The Streaming method is used by the cluster to sync between standby and primary.
The new standby server and cluster status showing HOT STANDBY on port 5432
...
The shipping mode configuration and the time difference between standby and primary
The message indicates that the configuration is ready for switchover.
User scripts that can be executed post the switchover process on new primary and standby.
Click Start to start the switchover process.
The configuration is In Sync with the WAL Shipping method in the reverse direction.
The observer is enabled once the switchover is completed and is now monitored.
The new primary server and Cluster status show ONLINE on port 5433.
The WAL Shipping method is used by the cluster to sync between standby and primary.
The new standby server and cluster status showing HOT STANDBY on port 5433.
