Oracle Cloud Infrastructure Documentation

Failing a 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.

    For information about using the API and signing requests, see REST API documentation and Security Credentials. For information about SDKs, see SDKs and the CLI.