Page Comparison

Requirement

1. Database Status

   1. Standby server should be “HOT STANDBY“/”WARM STANDBY”

1. Trigger Activate

2. Disable Control Center Behaviors

   • Disable Observer: Turn off the observer node to ensure a smooth switchover without conflicting activities

   • Disable Auto Update: Suspend any automatic update processes during the switchover procedure

3. Promote Standby database to Primary database

   Code Block
   pg_ctl promote -D data_dir

   • The standby server stops streaming data replication from the primary server.

   • The standby server disconnects from the primary server.

   • The standby server modifies its own configuration to become a primary server.

   • The standby server starts accepting read and write operations.

   • Clients and applications that were connecting to the old primary server may need to be reconfigured to connect to the newly promoted primary server.

4. Switch Role and Persist new configuration data with failover mark

5. Enable Control Center Behaviors

   • Enable Observer

   • Enable Auto Update: Restore the automatic update processes

6. Execute User Script on New Primary and Standby Servers

   • Run any necessary user scripts on the new primary and new standby servers to complete the switchover process.