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.
Extra nodes provide improved performance and durability for a database system. They scale out reads to reduce query latency.
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 resources:
Allow group <postgresql-admin-group> to manage postgres-db-systems in compartment <database_compartment>
Allow group <postgresql-admin-group> to manage postgres-backups in compartment <database_compartment>
Allow group <postgresql-admin-group> to manage postgres-configurations in compartment <database_compartment>
Allow group <postgresql-admin-group> to read postgres-work-requests in compartment <database_compartment>For more information, see OCI Database with PostgreSQL Policies.