Adding a Node

Add a read replica node to an existing OCI Database with PostgreSQL database system.

    1. Open the navigation menu and select Databases. Under PostgreSQL, select DB Systems.
    2. (Optional) In the List scope section, under Compartment, select a compartment.
    3. Select the name of the database system that you want to add nodes to.
    4. On the database system details page, under Resources, click Database system nodes.
    5. Select Add node.
    6. In the Add node window, provide values for the following:
      • Name: Enter a name for the new node.
      • Description: Enter a description for the new node.
      • Private IP address: Enter a private IP address for the new node. The IP address must belong to the specified subnet IP range and should not be used by other Compute instances. The value is optional. If an IP address isn't provided, one is chosen from among the available IP addresses of the database system subnet.
    7. Select Add.
  • Use the oci psql db-system patch command and required parameters to add a node to a database system:

    oci psql db-system patch --db-system-id <database_OCID> [OPTIONS]

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

  • Run the PatchDbSystem operation to add or remove nodes.

    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.