Oracle Cloud Infrastructure Documentation

Failing an OCI Database with PostgreSQL Database System Over to Another Node

Failover to an existing read replica node of an OCI Database with PostgreSQL database system.

  • You can't use the Console to failover a database system to another node.

  • Use the oci psql db-system failover command and required parameters to failover a database system to an existing available node:

    oci psql db-system failover --db-system-id <database_system_OCID> [OPTIONS]

    For a complete list of parameters and values for CLI commands, see the CLI Command Reference.

  • Run the FailoverDbSystem operation to failover a database system to an existing available node.