Switchover a PostgreSQL Node
A clear, step-by-step guide that details the process of switching over a PostgreSQL node within your cluster. This overview focuses on executing the essential commands to transfer primary responsibilities to a standby node, ensuring a seamless transition with minimal downtime—all without delving into advanced switchover configurations or long-term maintenance tasks.
Here's the primary node—your central hub of operations.
Press "Cluster Options" and then select the "Switchover" option to initiate the transition from the current primary node.
Choose one of the standby nodes in the cluster to become the new primary.
Type "switch me" to confirm your intent and continue.
Instantly, a REST API command is generated—your key to automating future switchover processes with your DEVOPS tool.
Once everything is configured, press Submit to start the switchover process.
You'll see a status update indicating that the switchover process has begun, followed by confirmation that the primary node was successfully switched with the selected standby.
