PGD compatibility v6.5.0

Learn what EDB Postgres Distributed (PGD) 6 supports and is compatible with, including Postgres versions, operating systems and architectures, and extensions. Check this page before you deploy or upgrade a cluster to confirm your environment is supported.

PGD compatibility with Postgres versions

PGD supports the following minimum minor version, per major version, across community Postgres, EDB Postgres Extended (PGE), and EDB Postgres Advanced Server (EPAS).

PGD 6Community PostgresEDB Postgres ExtendedEDB Postgres Advanced Server
6.5.018.1.0+18.6.0+18.6.0+
6.5.017.5.0+17.11.0+17.11.0+
6.5.016.9.0+16.15.0+16.15.0+
6.5.015.13.0+15.19.0+15.19.0+
6.5.014.18.0+14.24.0+14.24.0+
Important

PGD 6.5.0 requires EDB Postgres Extended or EDB Postgres Advanced Server 14.24, 15.19, 16.15, 17.11, or 18.6, due to internal compatibility changes in PGD 6.5.0. This requirement doesn't apply to community Postgres.

PGD 6.0 through 6.4 aren't compatible with EDB Postgres Extended or EDB Postgres Advanced Server 14.24, 15.19, 16.15, 17.11, or 18.6, or later. Upgrade to PGD 6.5.0 or later if you're upgrading Postgres, EDB Postgres Extended, or EDB Postgres Advanced Server to one of these versions. See Performing a combined minor upgrade for the steps.

Note

Postgres versions 14.24, 15.19, 16.15, 17.11, and 18.6 add the output_plugin_libraries parameter. On community Postgres, you must add bdr to output_plugin_libraries and reload the configuration when you upgrade to one of these versions. See Postgres configuration for the required setting and instructions. For EPAS or PGE, no action is required.

EDB recommends that you use the latest minor version of any Postgres major version with a supported PGD.

PGD compatibility with operating systems and architectures

PGD supports the following operating systems and architectures:

Operating Systemx86_64
(amd64)
ppc64learm64/
aarch64
RHEL 8YesYes
RHEL 9YesYesYes
Oracle Linux 8Yes
Oracle Linux 9Yes
Rocky Linux/AlmaLinuxYes
SUSE Linux Enterprise Server 15SP6YesYes
SUSE Linux Enterprise Server 15SP7YesYes
Ubuntu 22.04Yes
Ubuntu 24.04Yes
Debian 12YesYes
IBM Linux OneYes

PGD compatibility with extensions

PGD supports the following Postgres contrib modules and EDB extensions. The distributed nature of PGD means that you must carefully consider and plan the extensions you select and install. For the full list of extensions available across EDB's Postgres distributions, see Postgres extensions available by deployment. For steps to install and configure an extension in a PGD cluster, see Installing extensions.

Postgres contrib extensions

Contrib extensions ship with community Postgres, EDB Postgres Extended, and EDB Postgres Advanced Server, so no separate download is needed. The following contrib extensions are compatible with PGD on all supported Postgres versions.

ExtensionCompatible versions
amcheckAll supported versions
bloomAll supported versions
btree_ginAll supported versions
btree_gistAll supported versions
citextAll supported versions
cubeAll supported versions
dblinkAll supported versions
earthdistanceAll supported versions
file_fdwAll supported versions
fuzzystrmatchAll supported versions
hstoreAll supported versions
intarrayAll supported versions
isnAll supported versions
loAll supported versions
ltreeAll supported versions
pg_buffercacheAll supported versions
pg_prewarmAll supported versions
pg_stat_statementsAll supported versions
pg_trgmAll supported versions
pg_visibilityAll supported versions
pgcryptoAll supported versions
pgrowlocksAll supported versions
pgstattupleAll supported versions
postgres_fdwAll supported versions
segAll supported versions
tablefuncAll supported versions
unaccentAll supported versions
uuid-osspAll supported versions, except EDB Postgres Advanced Server 18

Third-party and EDB extensions

These extensions aren't bundled with Postgres. You install them separately, and most need an entry in shared_preload_libraries before you create them.

ExtensionCompatible versions
Apache AGEAll supported versions, except EDB Postgres Advanced Server 14 through 16 and EDB Postgres Extended 14
hypopgAll supported versions
pg_cronAll supported versions
pg_hint_planPostgres and EDB Postgres Extended, all supported versions.
pg_ivmAll supported versions, except EDB Postgres Advanced Server 14 through 16
pg_partmanAll supported versions
pg_repackAll supported versions
pg_squeezeAll supported versions
pgauditAll supported versions
pgttAll supported versions
pgvectorAll supported versions
plpgsql_checkAll supported versions, except Postgres 14
PostGISAll supported versions

EDB Postgres Advanced Server extensions

These packages are built into EDB Postgres Advanced Server and don't need a separate download.

ExtensionCompatible versions
dbms_aqAll supported versions
dbms_pipeAll supported versions
edb_genAll supported versions
edb_pg_tunerAll supported versions
edb_wait_statesAll supported versions
Note

dbms_aq queue table DDL and queue metadata replicate to all nodes. Enqueued messages don't replicate. They stay local to the node where they're created.