Adding an OCI Database with PostgreSQL Database System Node

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

    1. On the Database systems list page, select the database system that you want to work with. If you need help finding the list page or the database system, see Listing OCI Database with PostgreSQL Database Systems.
      The database system's details page opens.
    2. Select Database system nodes.
      The Database system nodes page appears.
    3. Select Add node.
      The Add node panel opens.
    4. Enter the following information:
      • Name: Enter a name for the new node.
      • Description: (Optional) Enter a description for the new node.
      • Private IP address: (Optional) 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.
    5. Select Add.
    The node you added appears in the Nodes list.
  • 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.