Managing Database System Nodes
Manage OCI Database with PostgreSQL database system nodes, including read replica nodes.
Every database system requires at least one node, which is the primary node. More nodes can be created and used as read-only replica nodes that can be used for read load balancing and failover. You can also enable a single reader endpoint for the database system to distribute connections across nodes.
Extra nodes provide improved performance and availability for a database system. Read replicas can be used to increase read scaling and potentially reduce latencies.
Manage nodes using the following tasks:
Required IAM Policy
The following policy statements allow a group of administrators to manage OCI Database with PostgreSQL database systems:
Allow group <postgresql-admin-group> to read compartments in tenancy
Allow group <postgresql-admin-group> to manage postgres-db-systems in [ tenancy | compartment <compartment_name> | compartment id <compartment_OCID> ]
Allow group <postgresql-admin-group> to manage postgres-backups in [ tenancy | compartment <compartment_name> | compartment id <compartment_OCID> ]
Allow group <postgresql-admin-group> to read postgres-work-requests in [ tenancy | compartment <compartment_name> | compartment id <compartment_OCID> ]
Allow group <postgresql-admin-group> to manage postgres-configuration in [ tenancy | compartment <compartment_name> | compartment id <compartment_OCID> ]
Allow group <postgresql-admin-group> to manage virtual-network-family in [ tenancy | compartment <compartment_name> | compartment id <compartment_OCID> ]
Allow group <postgresql-admin-group> to read secret-family in [ tenancy | compartment <compartment_name> | compartment id <compartment_OCID> ]
Allow group <postgresql-admin-group> to read vaults in [ tenancy | compartment <compartment_name> | compartment id <compartment_OCID> ]
Allow group <postgresql-admin-group> to read metrics in [ tenancy | compartment <compartment_name> | compartment id <compartment_OCID> ]
Allow group <postgresql-admin-group> to use tag-namespaces in tenancyFor more information, see OCI Database with PostgreSQL Policies.