Supported Extensions for OCI Database with PostgreSQL
All OCI Database with PostgreSQL database systems support extensions, many of which are enabled by default.
Most extensions supported by OCI Database with PostgreSQL are available for immediate use, but certain extensions must be enabled by administrators through custom configurations. After a configuration with enabled extensions is associated with a database system, database admin users can manage those extensions when connected to the database.
For more information, see Enabling Extensions for an OCI Database with PostgreSQL Database System. To find out which extensions are enabled in a particular configuration, see Getting an OCI Database with PostgreSQL Configuration's Details.
| Extension | V14 | V15 | V16 | V17 | Available by default | Upgrade action | Comments |
|---|---|---|---|---|---|---|---|
address_standardizer |
3.4.2 | 3.4.2 | 3.4.2 | 3.4.4 | No | ALTER | |
address_standardizer_data_us |
3.4.2 | 3.4.2 | 3.4.2 | 3.4.4 | No | ALTER | Owns US address reference tables (us_lex, us_gaz, us_rules). |
amcheck |
1.3 | 1.3 | 1.3 | 1.4 | No | ALTER | |
anon |
1.3.2 | 1.3.2 | 1.3.2 | 1.3.2 | No | DROP/CREATE | Recreate-only per upstream docs; also owns masking metadata tables and policies. Back them up, drop before metadata dump, then recreate and reapply after upgrade. |
btree_gin |
1.3 | 1.3 | 1.3 | 1.3 | Yes | ALTER | |
btree_gist |
1.6 | 1.7 | 1.7 | 1.7 | Yes | ALTER | |
citext |
1.6 | 1.6 | 1.6 | 1.6 | Yes | ALTER | |
cube |
1.5 | 1.5 | 1.5 | 1.5 | Yes | ALTER | |
dblink |
1.2 | 1.2 | 1.2 | 1.2 | No | ALTER | |
dict_int* |
1.0 | 1.0 | 1.0 | 1.0 | Yes | ALTER | OCI note: not all functionality can be enabled. |
fuzzystrmatch |
1.1 | 1.1 | 1.2 | 1.2 | Yes | ALTER | |
hstore |
1.8 | 1.8 | 1.8 | 1.8 | Yes | ALTER | |
hypopg |
1.4.2 | 1.4.2 | 1.4.2 | 1.4.2 | No | ALTER | |
intarray |
1.5 | 1.5 | 1.5 | 1.5 | Yes | ALTER | |
isn |
1.2 | 1.2 | 1.2 | 1.2 | Yes | ALTER | |
lo |
1.1 | 1.1 | 1.1 | 1.1 | Yes | ALTER | |
ltree |
1.2 | 1.2 | 1.2 | 1.3 | Yes | ALTER | |
orafce |
4.16.3 | 4.16.3 | 4.16.3 | 4.16.3 | No | ALTER | |
pg_buffercache |
1.3 | 1.3 | 1.4 | 1.5 | No | ALTER | |
pg_cron |
1.6 | 1.6 | 1.6 | 1.6 | No | ALTER | Owns cron.job metadata tables; preload shared_preload_libraries=pg_cron and preserve cron.database_name. |
pg_partman |
5.0.1 | 5.0.1 | 5.0.1 | 5.2.4 | No | ALTER | Owns part_config metadata; if BGW is used, preload shared_preload_libraries=pg_partman_bgw. |
pg_repack |
1.5.0 | 1.5.0 | 1.5.0 | 1.5.0 | No | ALTER | |
pg_squeeze |
1.6 | 1.6 | 1.6 | 1.9 | No | ALTER | Owns squeeze metadata tables; preload shared_preload_libraries=pg_squeeze before upgrade. |
pg_stat_statements |
1.9 | 1.10 | 1.10 | 1.11 | No | ALTER | Preload shared_preload_libraries=pg_stat_statements. |
pg_trgm |
1.6 | 1.6 | 1.6 | 1.6 | Yes | ALTER | |
pgaudit |
1.6.2 | 1.7 | 16.0 | 17.1 | No | ALTER | Preload shared_preload_libraries=pgaudit; ensure the extension exists before setting pgaudit.log. |
pgcrypto |
1.3 | 1.3 | 1.3 | 1.3 | Yes | ALTER | |
pglogical |
2.4.4 | 2.4.6 | 2.4.6 | 2.4.6 | No | ALTER | Owns pglogical.* metadata tables; preload shared_preload_libraries=pglogical, drop source replication slots before metadata dump, and recreate after upgrade. |
pgrowlocks |
1.2 | 1.2 | 1.2 | 1.2 | No | ALTER | |
pgstattuple |
1.5 | 1.5 | 1.5 | 1.5 | No | ALTER | |
pgvector |
0.8.0 | 0.8.0 | 0.8.0 | 0.8.0 | No | ALTER | Stores vectors in user tables; no extension-owned metadata tables. |
plpgsql |
1.0 | 1.0 | 1.0 | 1.0 | Yes | N/A | Installed as the built-in PL/pgSQL language; no separate extension upgrade step. |
postgis |
3.4.2 | 3.4.2 | 3.4.2 | 3.4.4 | No | ALTER | Can be enabled in the OC1 realm only. Owns reference tables such as spatial_ref_sys; treat the PostGIS family as a unit during upgrade. |
postgis_raster |
3.4.2 | 3.4.2 | 3.4.2 | 3.4.4 | No | ALTER | Can be enabled in the OC1 realm only. Upgrade with the PostGIS family. |
postgis_tiger_geocoder |
3.4.2 | 3.4.2 | 3.4.2 | 3.4.4 | No | ALTER | Can be enabled in the OC1 realm only. Owns geocoder data tables; upgrade with the PostGIS family. |
postgis_topology |
3.4.2 | 3.4.2 | 3.4.2 | 3.4.4 | No | ALTER | Can be enabled in the OC1 realm only. Owns topology.* metadata tables; upgrade with the PostGIS family. |
postgres_fdw |
1.1 | 1.1 | 1.1 | 1.1 | No | ALTER | |
seg |
1.4 | 1.4 | 1.4 | 1.4 | Yes | ALTER | |
tablefunc* |
1.0 | 1.0 | 1.0 | 1.0 | Yes | ALTER | OCI note: not all functionality can be enabled. |
tcn |
1.0 | 1.0 | 1.0 | 1.0 | Yes | ALTER | |
tsm_system_rows |
1.0 | 1.0 | 1.0 | 1.0 | Yes | ALTER | |
tsm_system_time |
1.0 | 1.0 | 1.0 | 1.0 | Yes | ALTER | |
unaccent* |
1.1 | 1.1 | 1.1 | 1.1 | Yes | ALTER | OCI note: not all functionality can be enabled. |
uuid-ossp |
1.1 | 1.1 | 1.1 | 1.1 | Yes | ALTER |
Stored Procedure Support
OCI Database with PostgreSQL supports the PL/pgSQL stored procedure language.