Activate Extensions
There are several PostgreSQL extensions preinstalled, that you can enable for your cluster. You can enable the extension by logging into your cluster and executing:
create extension <EXTENSION> CASCADE;
The following table shows which extensions are enabled by default and which can be enabled (PostgreSQL version 12):
Extension | Enabled | Version | Description |
|---|---|---|---|
plpython3u | X | 1.0 | PL/Python3U untrusted procedural language |
pg_stat_statements | X | 1.7 | track execution statistics of all SQL statements executed |
intarray | | 1.2 | functions, operators, and index support for 1-D arrays of integers |
pg_trgm | | 1.4 | text similarity measurement and index searching based on trigrams |
pg_cron | | 1.3 | Job scheduler for PostgreSQL |
set_user | | 3.0 | similar to SET ROLE but with added logging |
timescaledb | | 2.4.2 | Enables scalable inserts and complex queries for time-series data |
tablefunc | | 1.0 | functions that manipulate whole tables, including crosstab |
pg_auth_mon | X | 1.1 | monitor connection attempts per user |
plpgsql | X | 1.0 | PL/pgSQL procedural language |
pg_partman | | 4.5.1 | Extension to manage partitioned tables by time or ID |
hypopg | | 1.1.4 | Hypothetical indexes for PostgreSQL |
postgres_fdw | X | 1.0 | foreign-data wrapper for remote PostgreSQL servers |
btree_gin | | 1.3 | support for indexing common datatypes in GIN |
pg_stat_kcache | X | 2.2.0 | Kernel statistics gathering |
citext | | 1.6 | data type for case-insensitive character strings |
pgcrypto | | 1.3 | cryptographic functions |
earthdistance | | 1.1 | calculate great-circle distances on the surface of the Earth |
postgis | | 3.2.1 | PostGIS geometry and geography spatial types and functions |
cube | | 1.4 | data type for multidimensional cubes |
Note: With
select * from pg_available_extensions; you will see more available extensions, but many of them can't be enabled or used without superuser rights and thus aren't listed here.Last modified 4mo ago