Use Neon as your dev environment for AWS RDS: accelerate your workflow while reducing costs

Supported Postgres extensions

Neon supports the Postgres extensions shown in the following table. The supported version of the extension sometimes differs by Postgres version.

ExtensionPG14PG15PG16Notes
address_standardizer3.3.33.3.33.3.3
address_standardizer_data_us3.3.33.3.33.3.3
autoinc (spi)1.01.01.0
bloom1.01.01.0
btree_gin1.31.31.3
btree_gist1.61.71.7
citext1.61.61.6
cube1.51.51.5
dict_int1.01.01.0
earthdistance1.11.11.1
fuzzystrmatch1.11.11.1
h34.1.34.1.34.1.3Some components have been split out into the h3_postgis extension. Install both the h3 and h3_postgis extensions.
h3_postgis4.1.24.1.34.1.3Install with CREATE EXTENSION h3_postgis CASCADE; (requires postgis and postgis_raster)
hll2.182.182.18
hstore1.81.81.8
hypopg1.4.01.4.01.4.0
insert_username (spi)1.01.01.0
intagg1.11.11.1
intarray1.51.51.5
ip4r2.4.22.4.22.4.2
isn1.21.21.2
lo1.11.11.1
ltree1.21.21.2
moddatetime (spi)1.01.01.0
neon1.31.31.3
neon_utils1.01.01.0
pg_graphql1.4.01.4.01.4.0
pg_hashids1.2.11.2.11.2.1
pg_hint_plan1.4.11.5.01.6.0
pg_ivm1.71.71.7
pg_jsonschema0.2.00.2.00.2.0
pg_partman5.0.15.0.15.0.1
pg_prewarm1.21.21.2
pg_roaringbitmap0.50.50.5Install with CREATE EXTENSION roaringbitmap;
pg_stat_statements1.91.101.10
pg_tiktoken0.0.10.0.10.0.1The neon_superuser role has EXECUTE privilege on the pg_stat_statements_reset() function.
pg_trgm1.61.61.6
pg_uuidv71.01.01.0
pgcrypto1.31.31.3
pgjwt0.2.00.2.00.2.0
pgrouting3.4.23.4.23.4.2The PostGIS extension must be installed first.
pgrowlocks1.21.21.2
pgstattuple1.51.51.5
pgtap1.2.01.2.01.2.0
pgvector0.7.20.7.20.7.2Install with CREATE EXTENSION vector;
pgx_ulid0.1.30.1.30.1.3Install with CREATE EXTENSION ulid;
plcoffee3.1.53.1.53.1.8
plls3.1.53.1.53.1.8
plpgsql1.01.01.0Pre-installed with Postgres.
plpgsql_check2.5.32.5.32.5.3
plv83.1.103.1.103.1.10
postgis3.3.33.3.33.3.3
postgis_raster3.3.33.3.33.3.3
postgis_sfcgal1.3.81.3.81.3.8
postgis_tiger_geocoder3.3.33.3.33.3.3Cannot be installed using the Neon SQL Editor. Use your psql user credentials to install this extension.
postgis_topology3.3.33.3.33.3.3
prefix1.2.01.2.01.2.0
rdkit4.3.04.3.04.3.0
refint (spi)1.01.01.0
rum1.31.31.3
seg1.41.41.4
tablefunc1.01.01.0
tcn1.01.01.0
timescaledb2.10.12.10.12.13.0Only Apache-2 licensed features are supported. Compression is not supported.
tsm_system_rows1.01.01.0
tsm_system_time1.01.01.0
unaccent1.11.11.1
unit777
uuid-ossp1.11.11.1Double-quote the extension name when installing: CREATE EXTENSION "uuid-ossp"
wal2json2.52.52.5CREATE EXTENSION not required. This decoder plugin is available by default but requires enabling logical replication in Neon.
xml21.11.11.1

Install an extension

Unless otherwise noted, supported extensions can be installed using CREATE EXTENSION syntax.

CREATE EXTENSION <extension_name>;

You can install extensions from the Neon SQL Editor or from a client such as psql that permits running SQL queries. For information about using the Neon SQL Editor, see Query with Neon's SQL Editor. For information about using the psql client with Neon, see Connect with psql.

Update an extension version

Neon updates supported extensions as new versions become available. Version updates are communicated in the Changelog. To check the current version of extensions you have installed, query the pg_extension table:

SELECT * FROM pg_extension;

You can update an extension to the latest version using ALTER EXTENSION <extension_name> UPDATE TO <new_version> syntax. For example:

ALTER EXTENSION vector UPDATE TO '0.7.0';

important

When Neon releases a new extension or new extension version, a compute restart is required to make the new extension or extension version available for installation or update. A compute restart may occur on its own due to Neon's default Autosuspend behavior. However, if your compute never restarts because you disabled Autosuspend or because your compute is constantly active, you may need to force a restart. To force a restart, users on paid plans can temporarily set a compute's Suspend compute after a period of inactivity setting to 1 second (the default is 5 minutes). See Autosuspend configuration for instructions. After doing so, check the Operations page in the Neon Console to see if your compute restarted. Look for suspend_compute and start_compute actions. Alternatively, all Neon users can issue Suspend endpoint and Start endpoint API calls. Please be aware that restarting a compute temporarily interrupts any connections currently using the compute.

Extension support notes

  • Neon supports the uuid-ossp extension for generating UUIDs instead of the uuid extension.
  • The sslinfo extension is not supported. Neon handles connections via a proxy that checks SSL.
  • The pg_cron extension is not supported. Neon scales to zero when it is not being used, which means that a scheduler that runs inside the database cannot be implemented. Consider using an scheduler that runs externally instead.
  • The file_fdw extension is not supported. Files would not remain accessible when Neon scales to zero.

Request extension support

To request support for a Postgres extension, paid plan users can open a support ticket. Free plan users can submit a request via the feedback channel on our Discord Server.

Custom-built extensions

For Enterprise plan customers, Neon supports custom-built Postgres extensions for exclusive use with your Neon account. If you developed your own Postgres extension and want to use it with Neon, please reach out to us as described above. Please include the following information in your request:

  • A repository link or archive file containing the source code for your extension
  • A description of what the extension does, instructions for compiling it, and any prerequisites
  • Whether an NDA or licensing agreement is necessary for Neon to provide support for your extension

Please keep in mind that certain restrictions may apply with respect to Postgres privileges and local file system access. Additionally, Neon features such as Autoscaling and Autosuspend may limit the types of extensions we can support.

Depending on the nature of your extension, Neon may also request a liability waiver.

Need help?

Join our Discord Server to ask questions or see what others are doing with Neon. Users on paid plans can open a support ticket from the console. For more detail, see Getting Support.

Last updated on

Edit this page
Was this page helpful?