Troubleshooting OCI Database with PostgreSQL
Use troubleshooting information to identify and address common issues that can occur while working with OCI Database with PostgreSQL.
Extension Creation Fails with "Not Allowed" Error
When creating an extension in an OCI Database with PostgreSQL environment, you receive an error that the extension is not allowed.
Most extensions supported by OCI Database with PostgreSQL are available for immediate use, but some require an administrator to enable the extension through a custom configuration. For example, the pg_stat_statements extension might be listed as supported, but isn't immediately usable.
If you try to create the pg_stat_statements extension and it's not enabled by the administrator, you might see an error. For example:
postgres=> CREATE EXTENSION pg_stat_statements;
ERROR: Extension : pg_stat_statements is not allowed
To check if an extension such as pg_stat_statements is available, you can see the pg_available_extensions catalog, which shows the latest extensions and their version information. For example:
postgres=> SELECT * FROM pg_available_extensions WHERE name = 'pg_stat_statements';To see which extensions are enabled for your tenancy by administrators, use oci.admin_enabled_extensions. For example:
postgres=> SHOW oci.admin_enabled_extensions;
oci.admin_enabled_extensions
------------------------------
postgres_fdw
(1 row)
If pg_stat_statements isn't listed, it means it's not enabled yet.