Supported Extensions for Render Postgres
Render Postgres databases support a wide variety of 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:
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:
| Extension | Notes |
|---|---|
|
PostgreSQL 14 or later. | |
|
PostgreSQL 16 or later. | |
|
PostgreSQL 14 or later. Background worker not enabled. Database must have been created after February 5, 2026. | |
|
PostgreSQL 16 or later. Requires installing the | |
|
Currently not available for PostgreSQL 16 or later. | |
|
PostgreSQL 14 or later. | |
|
Enable this extension with | |
|
This extension is enabled by default. | |
|
Database must have been created after January 12, 2023. Community features are not available. | |
PostgreSQL 11 and 12
On Render Postgres 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).
| Extension | Notes |
|---|---|
|
Not available on the Starter instance type for PostgreSQL 12 due to resource requirements. | |
Removing extensions
If you don't need some of these extensions and want to remove them from your PostgreSQL 11 or 12 database, please reach out to our support team in the Render Dashboard.