46+ PostgreSQL Extensions on DigitalOcean Managed PostgreSQL
DigitalOcean Managed PostgreSQL is a simple, no-frills managed Postgres. Enable pgvector, postgis, timescaledb (PG14-17), and pg_cron with a single CREATE EXTENSION over a normal connection.
AWS RDSEnables scalable inserts and complex queries for time-series data
Enables scalable inserts and complex queries for time-series data
vector data type and ivfflat and hnsw access methods
Job scheduler for PostgreSQL
Extension to manage partitioned tables by time or ID
Extension to manage partitioned tables by time or ID
Reorganize tables in PostgreSQL databases with minimal locks
Reorganize tables in PostgreSQL databases with minimal locks
provides auditing functionality
type for storing hyperloglog data
The pg_stat_monitor is a PostgreSQL Query Performance Monitoring tool, based on PostgreSQL contrib module pg_stat_statements. pg_stat_monitor provides aggregated statistics, client information, plan details including plan, and histogram information.
The pg_stat_monitor is a PostgreSQL Query Performance Monitoring tool, based on PostgreSQL contrib module pg_stat_statements. pg_stat_monitor provides aggregated statistics, client information, plan details including plan, and histogram information.
IPv4/v6 and IPv4/v6 range index type for PostgreSQL
bloom access method - signature file based index
support for indexing common datatypes in GIN
support for indexing common datatypes in GiST
data type for case-insensitive character strings
connect to other PostgreSQL databases from within a database
connect to other PostgreSQL databases from within a database
text search dictionary template for integers
calculate great-circle distances on the surface of the Earth
determine similarities and distance between strings
data type for storing sets of (key, value) pairs
functions, operators, and index support for 1-D arrays of integers
data types for international product numbering standards
data type for hierarchical tree-like structures
track planning and execution statistics of all SQL statements executed
track planning and execution statistics of all SQL statements executed
text similarity measurement and index searching based on trigrams
text similarity measurement and index searching based on trigrams
PostGIS geometry and geography spatial types and functions
foreign-data wrapper for remote PostgreSQL servers
data type for representing line segments or floating-point intervals
functions that manipulate whole tables, including crosstab
functions that manipulate whole tables, including crosstab
TABLESAMPLE method which accepts number of rows as a limit
TABLESAMPLE method which accepts time in milliseconds as a limit
TABLESAMPLE method which accepts time in milliseconds as a limit
generate universally unique identifiers (UUIDs)
How to enable extensions on DigitalOcean Managed PostgreSQL
DigitalOcean has no control-panel toggle, doctl command, or shared_preload_libraries setting for extensions. Your database user isn't a superuser. You enable supported extensions the standard way: run CREATE EXTENSION over a normal SQL connection.
SQL
Connect with psql (or any client) using your database credentials, then run:
-- Enable an extension
CREATE EXTENSION IF NOT EXISTS pgvector;
-- Upgrade an already-installed extension to the latest packaged version
ALTER EXTENSION pgvector UPDATE;
-- List what's currently installed
\dx
-- See everything available to install on this cluster
SELECT * FROM pg_available_extensions;
-- See the allow-list of extensions DigitalOcean permits
SELECT *
FROM pg_available_extension_versions
WHERE name = ANY(
string_to_array(current_setting('extwlist.extensions'), ',')
);Pre-enabled on DigitalOcean Managed PostgreSQL
These extensions ship enabled by default, no CREATE EXTENSION needed.
Notable absences
Extensions you might expect that aren't available on DigitalOcean Managed PostgreSQL, with workarounds where they exist.
postgisWhy missing: DigitalOcean publishes a separate supported-extensions table per PostgreSQL major, and the PG18 table is shorter than the others. The entire PostGIS family (postgis, pgrouting), timescaledb, pg_stat_statements, and h3/hll are not yet available on PG18 clusters.
Alternative: If you need these, provision the cluster on PG17 instead of PG18. The version is fixed at creation time and can't be downgraded later.
citusWhy missing: DigitalOcean only ships a curated allow-list of extensions and doesn't offer the distributed-Postgres sharding extensions; citus is not on that list for any major version.
Alternative: Scale vertically on a larger node, or use native partitioning with pg_partman (which DigitalOcean does support) for large tables.
hypopgWhy missing: Index-tuning and maintenance extensions like hypopg, plv8, pglogical, and pg_squeeze aren't in DigitalOcean's supported-extensions tables, and there's no superuser access to install them yourself.
Alternative: Use EXPLAIN with real indexes on a forked/standby database for tuning, and request additions through DigitalOcean's ideas portal.
Can you install custom extensions on DigitalOcean Managed PostgreSQL?
DigitalOcean only supports a selected allow-list of PostgreSQL extensions: "We only support selected PostgreSQL extensions." Your database role is not a superuser, so you can't install arbitrary or custom-compiled extensions, and a subset of untrusted extensions is further governed by an extwlist.extensions allow-list enforced at CREATE EXTENSION time. To get a new extension added, request it through DigitalOcean's product ideas portal.
Frequently asked questions
How do I enable an extension on DigitalOcean Managed PostgreSQL?
Does DigitalOcean support timescaledb and pgvector?
Why is PostGIS not available on my PG18 DigitalOcean cluster?
Does DigitalOcean support pg_cron?
Can I install custom extensions on DigitalOcean PostgreSQL?
Other PostgreSQL providers
Manage your DigitalOcean Managed PostgreSQL database with 1bench
1bench is a modern GUI client for PostgreSQL. Connect to your DigitalOcean Managed PostgreSQL instance, install extensions, write queries, and inspect schemas without leaving the IDE.
Try 1bench for PostgreSQL