OCI Database with PostgreSQL Known Issues

These known issues have been identified in OCI Database with PostgreSQL.

The reader endpoint can't be enabled for some database systems

Details

Some OCI Database with PostgreSQL database systems created before November 1, 2024 can't have the reader endpoint enabled. Enabling the reader endpoint for these database systems fails with the following error message:

Reader endpoint is not supported for this db system yet.

New database systems don't experience this issue. For more information, see Enabling or Disabling the Database System Reader Endpoint.

Workaround
We're working on a resolution so that the reader endpoint can be enabled for all database systems.

Database system service limits in Saudi Arabia West (Jeddah)

Details
The limit on OCI Database with PostgreSQL database systems per tenancy for the Saudi Arabia West (Jeddah) (me-jeddah-1) region is currently two.
Workaround
We're working on a resolution to increase service limits for this region.

Can't create the pg_stat_statements extension

Details

The pg_stat_statements extension can't be created. When you try to create the extension, you might see an error message such as the following:

ERROR:  permission denied to create extension "pg_stat_statements"
HINT:  Must be superuser to create this extension.
Resolved
2024-11-26