Supported PostgreSQL Extensions
Render PostgreSQL databases support most popular extensions (pgvector, postgis, and so on). Your database’s PostgreSQL version determines exactly which extensions are supported, along with how you add them:
PostgreSQL 13 and later
To enable any supported extension, run the CREATE EXTENSION command like so:
CREATE EXTENSION postgis;To run this command, you can start a psql session in your terminal. Use the PSQL Command provided on your database’s Info page in the Render Dashboard.
Except where noted, these extensions are available for all databases running PostgreSQL 13 or later:
- adminpack
- amcheck
- autoinc
- bloom
- btree_gin
- btree_gist
- citext
- cube
- dblink
- dict_int
- dict_xsyn
- earthdistance
- file_fdw
- fuzzystrmatch
- hstore
- hstore_plperl
- hstore_plperlu
- insert_username
- intagg
- intarray
- isn
- jsonb_plperl
- jsonb_plperlu
- lo
- ltree
- moddatetime
- old_snapshot*
- *Requires PostgreSQL 14 or later.
- pageinspect
- pg_buffercache
- pg_freespacemap
- pg_ivm
- pg_prewarm
- pg_similarity*
- *This extension is currently not available for PostgreSQL 16.
- pg_stat_statements
- pg_surgery*
- *Requires PostgreSQL 14 or later.
- pg_trgm
- pg_visibility
- pgaudit
- pgcrypto
- pgrowlocks
- pgstattuple
- pgvector*
- *Enable this extension with
CREATE EXTENSION vector;
- *Enable this extension with
- plpgsql*
- *This extension is enabled by default.
- postgis
- postgis_raster
- postgis_tiger_geocoder
- postgis_topology
- refint
- seg
- sslinfo
- tablefunc
- tcn
- timescaledb*
- *Database must have been created after 12 January 2023. Community features are not available.
- tsm_system_rows
- tsm_system_time
- unaccent
- uuid-ossp
- xml2
PostgreSQL 11 and 12
On Render databases running PostgreSQL 11 or 12, supported extensions are enabled by default and cannot be customized. These extensions are enabled for all PostgreSQL 11 and 12 databases:
Some of these extensions (like postgis) create additional schemas (like topology) and tables (like spatial_ref_sys).
- bloom
- btree_gin
- btree_gist
- citext
- cube
- dblink
- dict_int
- dict_xsyn
- earthdistance
- fuzzystrmatch
- hstore
- intagg
- intarray
- isn
- lo
- ltree
- pg_buffercache
- pg_prewarm
- pg_stat_statements
- pg_trgm
- pgcrypto
- pgrowlocks
- pgstattuple
- pgvector
- *Database must have been created or received maintenance after 11 April 2024. Contact support for assistance.
- postgis
- Not available on the Starter instance type for PostgreSQL 12, due to resource requirements.
- postgis_tiger_geocoder
- postgis_topology
- tablefunc
- unaccent
- uuid-ossp
Removing extensions
If you don’t need some of these extensions and want to remove them from your PostgreSQL 11 or 12 database, email support and we’ll be happy to delete them for you.