/
switchover 

switchover 

Owned by Vijayganesh Sivaprakasam
Nov 20, 2024
2 min read
dbvcli switchover {-d|--name} CONFIGURATION_NAME [--OPTIONS]

Swap the roles of the primary and standby clusters

Option

Type

Description

Option

Type

Description

--user-script

key=val

optional script or scripts to execute after switchover on primary or standby host (key must be primary or standby host; value must be an existing user script)

-bash-4.2$ ./dbvcli -d PG5432 switchover Connecting to the Control Center at centlin72.oraclekiwi.co.nz:4433 ✓ Checking available actions for this configuration ✓ Configuration PG5432 (centlin71.oraclekiwi.co.nz -> centlin72.oraclekiwi.co.nz) ┌───────────────┐┌───────────────┐ │ ││ │ │ Primary ││ Standby │ │ ││ │ │ ONLINE ││ HOT STANDBY │ │ ││ │ └───────────────┘└───────────────┘ Gathering information required for switchover ✓ Optional User Scripts 1/2 There are no scripts defined for host centlin72.oraclekiwi.co.nz Optional User Scripts 2/2 There are no scripts defined for host centlin71.oraclekiwi.co.nz Confirmation This configuration is ready for switchover. Select Yes to proceed with swapping the roles of the primary and standby databases, or No to cancel the operation. Confirm Switchover: (•) Yes ( ) No 2024-11-01 13:35:51 2024-11-01 13:35:51 Preparing for switchover 2024-11-01 13:35:51 Disabling Observer 2024-11-01 13:35:51 done 2024-11-01 13:35:51 Switching cluster from primary to standby 2024-11-01 13:35:51 Using pg_ctl to stop cluster at /u01/PG5432 on 5432... 2024-11-01 13:35:51 pg_ctl: waiting for server to shut down.... done 2024-11-01 13:35:51 pg_ctl: server stopped 2024-11-01 13:35:51 done 2024-11-01 13:35:51 Setting to standby 2024-11-01 13:35:52 done 2024-11-01 13:35:52 Switching cluster from standby to primary 2024-11-01 13:35:52 Using pg_ctl to stop cluster at /u01/PG5432 on 5432... 2024-11-01 13:35:52 pg_ctl: waiting for server to shut down.... done 2024-11-01 13:35:52 pg_ctl: server stopped 2024-11-01 13:35:52 done 2024-11-01 13:35:52 done 2024-11-01 13:35:52 Switching primary and standby roles 2024-11-01 13:35:52 Primary database host is now centlin72.oraclekiwi.co.nz 2024-11-01 13:35:52 Standby database host is now centlin71.oraclekiwi.co.nz 2024-11-01 13:35:52 Waiting for Agents to respond to role switch 2024-11-01 13:35:52 Starting primary cluster 2024-11-01 13:35:52 Using pg_ctl to start cluster at /u01/PG5432 on 5432... 2024-11-01 13:35:52 pg_ctl: waiting for server to start....2024-11-01 13:35:52.258 NZDT [12118] LOG: redirecting log output to logging collector process 2024-11-01 13:35:52 pg_ctl: 2024-11-01 13:35:52.258 NZDT [12118] HINT: Future log output will appear in directory "log". 2024-11-01 13:35:52 pg_ctl: done 2024-11-01 13:35:52 pg_ctl: server started 2024-11-01 13:35:52 done 2024-11-01 13:35:52 Perform post-starting process in primary cluster 2024-11-01 13:35:52 Refreshed replication slot after primary cluster start up 2024-11-01 13:35:52 Starting standby cluster 2024-11-01 13:35:52 Using pg_ctl to start cluster at /u01/PG5432 on 5432... 2024-11-01 13:35:52 pg_ctl: waiting for server to start....2024-11-01 13:35:52.651 NZDT [5091] LOG: redirecting log output to logging collector process 2024-11-01 13:35:52 pg_ctl: 2024-11-01 13:35:52.651 NZDT [5091] HINT: Future log output will appear in directory "log". 2024-11-01 13:35:52 pg_ctl: done 2024-11-01 13:35:52 pg_ctl: server started 2024-11-01 13:35:52 done 2024-11-01 13:35:52 Validate primary cluster 2024-11-01 13:35:52 Force switching wal 2024-11-01 13:35:53 done 2024-11-01 13:35:53 Waiting for LSN 0/4B000250 to be replicated to new standby 2024-11-01 13:35:53 done 2024-11-01 13:35:53 Validate standby cluster 2024-11-01 13:35:53 done 2024-11-01 13:35:53 Applying Observer settings 2024-11-01 13:35:53 Enabling Observer 2024-11-01 13:35:53 done 2024-11-01 13:35:53 Task succeeded

Related content