Skip to main content

Extension versions per PostgreSQL release

Extension availability and versions in Aiven for PostgreSQL® vary by PostgreSQL major version, with each extension having one default version per PostgreSQL release.

PostgreSQL 18 extensions

Extension nameDefault versionSupported versions
aiven_extras1.1.181.1.18
bloom1.01.0
bool_plperl1.01.0
btree_gin1.31.0, 1.1, 1.2, 1.3
btree_gist1.81.2, 1.3, 1.4, 1.5, 1.6, 1.7, 1.8
citext1.81.4, 1.5, 1.6, 1.7, 1.8
cube1.51.2, 1.3, 1.4, 1.5
dblink1.21.2
dict_int1.01.0
earthdistance1.21.1, 1.2
fuzzystrmatch1.21.1, 1.2
hstore1.81.4, 1.5, 1.6, 1.7, 1.8
intagg1.11.1
intarray1.51.2, 1.3, 1.4, 1.5
ip4r2.42.4
isn1.31.1, 1.2, 1.3
jsonb_plperl1.01.0
lo1.21.1, 1.2
ltree1.31.1, 1.2, 1.3
pg_buffercache1.61.2, 1.3, 1.4, 1.5, 1.6
pg_cron1.61.0, 1.1, 1.2, 1.3, 1.4, 1.4-1, 1.5, 1.6
pg_partman5.2.45.2.4
pg_prewarm1.21.1, 1.2
pg_repack1.5.21.5.2
pg_stat_statements1.121.10, 1.11, 1.12, 1.4, 1.5, 1.6, 1.7, 1.8, 1.9
pg_trgm1.61.3, 1.4, 1.5, 1.6
pgcrypto1.41.3, 1.4
pgrowlocks1.21.2
pgstattuple1.51.4, 1.5
plperl1.01.0
plpgsql1.01.0
postgres_fdw1.21.0, 1.1, 1.2
seg1.41.1, 1.2, 1.3, 1.4
sslinfo1.21.2
tablefunc1.01.0
tcn1.01.0
tsm_system_rows1.01.0
tsm_system_time1.01.0
unaccent1.11.1
unit71, 2, 3, 4, 5, 6, 7
uuid-ossp1.11.1
vector0.8.10.8.1

PostgreSQL 17 extensions

Extension nameDefault versionSupported versions
address_standardizer3.5.03.3.5, 3.5.0
address_standardizer_data_us3.5.03.3.5, 3.5.0
aiven_extras1.1.181.1.18
anon2.2.12.2.1
bloom1.01.0
bool_plperl1.01.0
btree_gin1.31.0, 1.1, 1.2, 1.3
btree_gist1.71.2, 1.3, 1.4, 1.5, 1.6, 1.7
citext1.61.4, 1.5, 1.6
cube1.51.2, 1.3, 1.4, 1.5
dblink1.21.2
dict_int1.01.0
earthdistance1.21.1, 1.1_aiven, 1.2
fuzzystrmatch1.21.1, 1.2
h34.1.30.1.0, 0.2.0, 0.3.0, 0.3.1, 0.3.2, 0.4.0, 1.0.0, 1.0.1, 1.0.2, 1.0.3, 1.0.4, 1.0.5, 1.0.6, 3.4.0, 3.4.1, 3.5.0, 3.6.0, 3.6.1, 3.6.2, 3.6.3, 3.6.4, 3.6.5, 3.7.0, 3.7.1, 3.7.2, 4.0.0, 4.0.1, 4.0.2, 4.0.3, 4.1.0, 4.1.1, 4.1.2, 4.1.3
h3_postgis4.1.34.0.0, 4.0.1, 4.0.2, 4.0.3, 4.1.0, 4.1.1, 4.1.2, 4.1.3
hll2.182.10, 2.11, 2.12, 2.13, 2.14, 2.15, 2.16, 2.17, 2.18
hstore1.81.4, 1.5, 1.6, 1.7, 1.8
intagg1.11.1
intarray1.51.2, 1.3, 1.4, 1.5
ip4r2.42.4
isn1.21.1, 1.2
jsonb_plperl1.01.0
lo1.11.1
ltree1.31.1, 1.2, 1.3
pg_buffercache1.51.2, 1.3, 1.4, 1.5
pg_cron1.61.0, 1.1, 1.2, 1.3, 1.4, 1.4-1, 1.5, 1.6
pg_partman4.7.44.7.4
pg_prewarm1.21.1, 1.2
pg_repack1.5.11.5.1
pg_similarity1.01.0
pg_stat_monitor2.12.0, 2.1
pg_stat_statements1.111.10, 1.11, 1.4, 1.5, 1.6, 1.7, 1.8, 1.9
pg_trgm1.61.3, 1.4, 1.5, 1.6
pgaudit17.017.0
pgcrypto1.31.3
pgrouting3.1.33.1.3
pgrowlocks1.21.2
pgstattuple1.51.4, 1.5
plperl1.01.0
plpgsql1.01.0
postgis3.5.03.3.5, 3.5.0
postgis_raster3.5.03.3.5, 3.5.0
postgis_sfcgal3.5.03.3.5, 3.5.0
postgis_tiger_geocoder3.5.03.3.5, 3.5.0
postgis_topology3.5.03.3.5, 3.5.0
postgres_fdw1.11.0, 1.1
rum1.31.0, 1.1, 1.2, 1.3
seg1.41.1, 1.2, 1.3, 1.4
sslinfo1.21.2
tablefunc1.01.0
tcn1.01.0
timescaledb2.21.32.17.2, 2.18.2, 2.19.3, 2.20.3, 2.21.3
tsm_system_rows1.01.0
tsm_system_time1.01.0
unaccent1.11.1
unit71, 2, 3, 4, 5, 6, 7
uuid-ossp1.11.1
vector0.8.10.8.1
vectorscale0.6.00.6.0

PostgreSQL 16 extensions

Extension nameDefault versionSupported versions
address_standardizer3.5.03.3.5, 3.5.0
address_standardizer_data_us3.5.03.3.5, 3.5.0
aiven_extras1.1.181.1.18
anon2.2.12.2.1
bloom1.01.0
bool_plperl1.01.0
btree_gin1.31.0, 1.1, 1.2, 1.3
btree_gist1.71.2, 1.3, 1.4, 1.5, 1.6, 1.7
citext1.61.4, 1.5, 1.6
cube1.51.2, 1.3, 1.4, 1.5
dblink1.21.2
dict_int1.01.0
earthdistance1.21.1, 1.1_aiven, 1.2
fuzzystrmatch1.21.1, 1.2
h34.1.30.1.0, 0.2.0, 0.3.0, 0.3.1, 0.3.2, 0.4.0, 1.0.0, 1.0.1, 1.0.2, 1.0.3, 1.0.4, 1.0.5, 1.0.6, 3.4.0, 3.4.1, 3.5.0, 3.6.0, 3.6.1, 3.6.2, 3.6.3, 3.6.4, 3.6.5, 3.7.0, 3.7.1, 3.7.2, 4.0.0, 4.0.1, 4.0.2, 4.0.3, 4.1.0, 4.1.1, 4.1.2, 4.1.3
h3_postgis4.1.34.0.0, 4.0.1, 4.0.2, 4.0.3, 4.1.0, 4.1.1, 4.1.2, 4.1.3
hll2.182.10, 2.11, 2.12, 2.13, 2.14, 2.15, 2.16, 2.17, 2.18
hstore1.81.4, 1.5, 1.6, 1.7, 1.8
intagg1.11.1
intarray1.51.2, 1.3, 1.4, 1.5
ip4r2.42.4
isn1.21.1, 1.2
jsonb_plperl1.01.0
lo1.11.1
ltree1.21.1, 1.2
pg_buffercache1.41.2, 1.3, 1.4
pg_cron1.61.0, 1.1, 1.2, 1.3, 1.4, 1.4-1, 1.5, 1.6
pg_partman4.7.44.7.4
pg_prewarm1.21.1, 1.2
pg_repack1.5.01.5.0
pg_similarity1.01.0
pg_stat_monitor1.01.0
pg_stat_statements1.101.10, 1.4, 1.5, 1.6, 1.7, 1.8, 1.9
pg_trgm1.61.3, 1.4, 1.5, 1.6
pgaudit16.016.0
pgcrypto1.31.3
pgrouting3.1.33.1.3
pgrowlocks1.21.2
pgstattuple1.51.4, 1.5
plperl1.01.0
plpgsql1.01.0
postgis3.5.03.3.5, 3.5.0
postgis_raster3.5.03.3.5, 3.5.0
postgis_sfcgal3.5.03.3.5, 3.5.0
postgis_tiger_geocoder3.5.03.3.5, 3.5.0
postgis_topology3.5.03.3.5, 3.5.0
postgres_fdw1.11.0, 1.1
rum1.31.0, 1.1, 1.2, 1.3
seg1.41.1, 1.2, 1.3, 1.4
sslinfo1.21.2
tablefunc1.01.0
tcn1.01.0
timescaledb2.21.32.13.1, 2.14.2, 2.15.3, 2.16.1, 2.17.2, 2.18.2, 2.19.3, 2.20.3, 2.21.3
tsm_system_rows1.01.0
tsm_system_time1.01.0
unaccent1.11.1
unit71, 2, 3, 4, 5, 6, 7
uuid-ossp1.11.1
vector0.8.10.8.1
vectorscale0.6.00.6.0

PostgreSQL 15 extensions

Extension nameDefault versionSupported versions
address_standardizer3.3.53.2.6, 3.3.5
address_standardizer_data_us3.3.53.2.6, 3.3.5
aiven_extras1.1.181.1.18
anon2.2.12.2.1
bloom1.01.0
bool_plperl1.01.0
btree_gin1.31.0, 1.1, 1.2, 1.3
btree_gist1.71.2, 1.3, 1.4, 1.5, 1.6, 1.7
citext1.61.4, 1.5, 1.6
cube1.51.2, 1.3, 1.4, 1.5
dblink1.21.2
dict_int1.01.0
earthdistance1.21.1, 1.1_aiven, 1.2
fuzzystrmatch1.11.1
h34.1.30.1.0, 0.2.0, 0.3.0, 0.3.1, 0.3.2, 0.4.0, 1.0.0, 1.0.1, 1.0.2, 1.0.3, 1.0.4, 1.0.5, 1.0.6, 3.4.0, 3.4.1, 3.5.0, 3.6.0, 3.6.1, 3.6.2, 3.6.3, 3.6.4, 3.6.5, 3.7.0, 3.7.1, 3.7.2, 4.0.0, 4.0.1, 4.0.2, 4.0.3, 4.1.0, 4.1.1, 4.1.2, 4.1.3
h3_postgis4.1.34.0.0, 4.0.1, 4.0.2, 4.0.3, 4.1.0, 4.1.1, 4.1.2, 4.1.3
hll2.182.10, 2.11, 2.12, 2.13, 2.14, 2.15, 2.16, 2.17, 2.18
hstore1.81.4, 1.5, 1.6, 1.7, 1.8
intagg1.11.1
intarray1.51.2, 1.3, 1.4, 1.5
ip4r2.42.4
isn1.21.1, 1.2
jsonb_plperl1.01.0
lo1.11.1
ltree1.21.1, 1.2
pg_buffercache1.31.2, 1.3
pg_cron1.61.0, 1.1, 1.2, 1.3, 1.4, 1.4-1, 1.5, 1.6
pg_partman4.7.44.7.4
pg_prewarm1.21.1, 1.2
pg_repack1.4.71.4.7
pg_similarity1.01.0
pg_stat_monitor1.01.0
pg_stat_statements1.101.10, 1.4, 1.5, 1.6, 1.7, 1.8, 1.9
pg_trgm1.61.3, 1.4, 1.5, 1.6
pgaudit1.71.7
pgcrypto1.31.3
pgrouting3.1.33.1.3
pgrowlocks1.21.2
pgstattuple1.51.4, 1.5
plperl1.01.0
plpgsql1.01.0
postgis3.3.53.2.6, 3.3.5
postgis_legacy3.33.3
postgis_raster3.3.53.2.6, 3.3.5
postgis_sfcgal3.3.53.2.6, 3.3.5
postgis_tiger_geocoder3.3.53.2.6, 3.3.5
postgis_topology3.3.53.2.6, 3.3.5
postgres_fdw1.11.0, 1.1
rum1.31.0, 1.1, 1.2, 1.3
seg1.41.1, 1.2, 1.3, 1.4
sslinfo1.21.2
tablefunc1.01.0
tcn1.01.0
timescaledb2.21.32.10.3, 2.11.2, 2.12.2, 2.13.1, 2.14.2, 2.15.3, 2.16.1, 2.17.2, 2.18.2, 2.19.3, 2.20.3, 2.21.3, 2.9.3
tsm_system_rows1.01.0
tsm_system_time1.01.0
unaccent1.11.1
unit71, 2, 3, 4, 5, 6, 7
uuid-ossp1.11.1
vector0.8.10.8.1

PostgreSQL 14 extensions

Extension nameDefault versionSupported versions
address_standardizer3.3.53.1.7, 3.2.6, 3.3.5
address_standardizer_data_us3.3.53.1.7, 3.2.6, 3.3.5
aiven_extras1.1.181.1.18
bloom1.01.0
bool_plperl1.01.0
btree_gin1.31.0, 1.1, 1.2, 1.3
btree_gist1.61.2, 1.3, 1.4, 1.5, 1.6
citext1.61.4, 1.5, 1.6
cube1.51.2, 1.3, 1.4, 1.5
dblink1.21.2
dict_int1.01.0
earthdistance1.21.1, 1.1_aiven, 1.2
fuzzystrmatch1.11.1
h34.1.30.1.0, 0.2.0, 0.3.0, 0.3.1, 0.3.2, 0.4.0, 1.0.0, 1.0.1, 1.0.2, 1.0.3, 1.0.4, 1.0.5, 1.0.6, 3.4.0, 3.4.1, 3.5.0, 3.6.0, 3.6.1, 3.6.2, 3.6.3, 3.6.4, 3.6.5, 3.7.0, 3.7.1, 3.7.2, 4.0.0, 4.0.1, 4.0.2, 4.0.3, 4.1.0, 4.1.1, 4.1.2, 4.1.3
h3_postgis4.1.34.0.0, 4.0.1, 4.0.2, 4.0.3, 4.1.0, 4.1.1, 4.1.2, 4.1.3
hll2.182.10, 2.11, 2.12, 2.13, 2.14, 2.15, 2.16, 2.17, 2.18
hstore1.81.4, 1.5, 1.6, 1.7, 1.8
intagg1.11.1
intarray1.51.2, 1.3, 1.4, 1.5
ip4r2.42.4
isn1.21.1, 1.2
jsonb_plperl1.01.0
lo1.11.1
ltree1.21.1, 1.2
pg_buffercache1.31.2, 1.3
pg_cron1.61.0, 1.1, 1.2, 1.3, 1.4, 1.4-1, 1.5, 1.6
pg_partman4.7.44.7.4
pg_prewarm1.21.1, 1.2
pg_repack1.4.71.4.7
pg_similarity1.01.0
pg_stat_monitor1.01.0
pg_stat_statements1.91.4, 1.5, 1.6, 1.7, 1.8, 1.9
pg_trgm1.61.3, 1.4, 1.5, 1.6
pgaudit1.6.11.6.1
pgcrypto1.31.3
pgrouting3.1.33.1.3
pgrowlocks1.21.2
pgstattuple1.51.4, 1.5
plperl1.01.0
plpgsql1.01.0
postgis3.3.53.1.7, 3.2.6, 3.3.5
postgis_legacy3.33.3
postgis_raster3.3.53.1.7, 3.2.6, 3.3.5
postgis_sfcgal3.3.53.1.7, 3.2.6, 3.3.5
postgis_tiger_geocoder3.3.53.1.7, 3.2.6, 3.3.5
postgis_topology3.3.53.1.7, 3.2.6, 3.3.5
postgres_fdw1.11.0, 1.1
rum1.31.0, 1.1, 1.2, 1.3
seg1.41.1, 1.2, 1.3, 1.4
sslinfo1.21.2
tablefunc1.01.0
tcn1.01.0
timescaledb2.19.32.10.3, 2.11.2, 2.12.2, 2.13.1, 2.14.2, 2.15.3, 2.16.1, 2.17.2, 2.18.2, 2.19.3, 2.5.2, 2.6.1, 2.7.2, 2.8.1, 2.9.3
tsm_system_rows1.01.0
tsm_system_time1.01.0
unaccent1.11.1
unit71, 2, 3, 4, 5, 6, 7
uuid-ossp1.11.1
vector0.8.10.8.1

PostgreSQL 13 extensions

Extension nameDefault versionSupported versions
address_standardizer3.3.52.5.8, 3.0.7, 3.1.7, 3.2.6, 3.3.5
address_standardizer_data_us3.3.52.5.8, 3.0.7, 3.1.7, 3.2.6, 3.3.5
aiven_extras1.1.181.1.18
bloom1.01.0
bool_plperl1.01.0
btree_gin1.31.0, 1.1, 1.2, 1.3
btree_gist1.51.2, 1.3, 1.4, 1.5
citext1.61.4, 1.5, 1.6
cube1.41.2, 1.3, 1.4
dblink1.21.2
dict_int1.01.0
earthdistance1.11.1
fuzzystrmatch1.11.1
hll2.182.10, 2.11, 2.12, 2.13, 2.14, 2.15, 2.16, 2.17, 2.18
hstore1.71.4, 1.5, 1.6, 1.7
intagg1.11.1
intarray1.31.2, 1.3
ip4r2.42.4
isn1.21.1, 1.2
jsonb_plperl1.01.0
lo1.11.1
ltree1.21.1, 1.2
pg_buffercache1.31.2, 1.3
pg_cron1.61.0, 1.1, 1.2, 1.3, 1.4, 1.4-1, 1.5, 1.6
pg_partman4.7.44.7.4
pg_prewarm1.21.1, 1.2
pg_repack1.4.71.4.7
pg_similarity1.01.0
pg_stat_monitor1.01.0
pg_stat_statements1.81.4, 1.5, 1.6, 1.7, 1.8
pg_trgm1.51.3, 1.4, 1.5
pgaudit1.5.11.5.1
pgcrypto1.31.3
pgrouting3.1.33.1.3
pgrowlocks1.21.2
pgstattuple1.51.4, 1.5
plperl1.01.0
plpgsql1.01.0
postgis3.3.52.5.8, 3.0.7, 3.1.7, 3.2.6, 3.3.5
postgis_legacy3.33.3
postgis_raster3.3.53.0.7, 3.1.7, 3.2.6, 3.3.5
postgis_sfcgal3.3.52.5.8, 3.0.7, 3.1.7, 3.2.6, 3.3.5
postgis_tiger_geocoder3.3.52.5.8, 3.0.7, 3.1.7, 3.2.6, 3.3.5
postgis_topology3.3.52.5.8, 3.0.7, 3.1.7, 3.2.6, 3.3.5
postgres_fdw1.01.0
rum1.31.0, 1.1, 1.2, 1.3
seg1.31.1, 1.2, 1.3
sslinfo1.21.2
tablefunc1.01.0
tcn1.01.0
timescaledb2.15.32.1.1, 2.10.3, 2.11.2, 2.12.2, 2.13.1, 2.14.2, 2.15.3, 2.2.1, 2.3.1, 2.4.2, 2.5.2, 2.6.1, 2.7.2, 2.8.1, 2.9.3
tsm_system_rows1.01.0
tsm_system_time1.01.0
unaccent1.11.1
unit71, 2, 3, 4, 5, 6, 7
uuid-ossp1.11.1
vector0.8.10.8.1