Some extensions for an OCI Database with PostgreSQL database system must be enabled by administrators through a configuration before they can be made available at the database level.
To enable extensions for an existing database system by copying its configuration, see the following steps. If you already have a configuration with extensions enabled, you can change the database system's configuration without creating a new one.
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 Database Systems.
On the database system details page, select the value next to Configuration, then select the configuration name.
On the configuration details page, select Copy configuration and extensions.
In the Copy configuration panel, in the Configure extensions section, select an extension or extensions from the PostgreSQL extensions list.
To enable default extensions, or extensions enabled by administrators as shown in the preceding steps, connect to the database and use a PostrgreSQL client to provide the following commands:
Verify the availability of the extension on the database. For example:
SELECT * FROM pg_available_extensions WHERE name = '<extension_name>';
After the availability of the extension is verified, enable it for the selected database:
CREATE EXTENSION <extension_name>;
Verify that the extension was enabled:
SELECT * FROM pg_extension WHERE extname = '<extension_name>';