Delphix Support Policies specifically list Major and Minor release coverage. If a minor release is listed as covered, then all patch releases under that minor release are certified.

RHEL/CentOS/SUSE 


Supported DBMS Version

PostgreSQL 9.4.x (Open Source & EDB)

PostgreSQL 9.5.x (Open Source & EDB)

PostgreSQL 9.6.x (Open source & EDB)

PostgreSQL 10.x (Open source & EDB)

PostgreSQL 11.x (Open source & EDB)

PostgreSQL 12.x (Open source & EDB)

Supported OS Version
RHEL/CentOS 7.3SupportedSupportedSupportedSupportedSupportedSupported
RHEL/CentOS 7.4SupportedSupportedSupportedSupportedSupportedSupported
RHEL/CentOS 7.5SupportedSupportedSupportedSupportedSupportedSupported
RHEL/CentOS 7.6SupportedSupportedSupportedSupportedSupportedSupported
RHEL/CentOS 7.7SupportedSupportedSupportedSupportedSupportedSupported
RHEL/CentOS 7.8SupportedSupportedSupportedSupportedSupportedSupported
SUSE 11.xSupportedNot SupportedNot SupportedNot SupportedNot SupportedNot Supported
SUSE 12.xSupportedSupportedSupportedSupportedSupportedNot Supported

where x represents the minor version.

All the available PostgreSQL Database Minor Versions will be supported for the above mentioned Major versions.

Plugin/Delphix Engine Compatibility

Plugins should be installed on compatible Delphix Engines per the table below:

Delphix Engine
Versions

Plugin Versions

PostgreSQL_1.0.1

PostgreSQL_1.0.2

PostgreSQL_1.1.0PostgreSQL_1.2.0PostgreSQL_1.3.0PostgreSQL_1.3.1PostgreSQL_1.3.2PostgreSQL_1.4.0
6.0.0.xNoNoYesYesYesYesYesYes
6.0.1.xNoNoYesYesYesYesYesYes
6.0.2.xNoNo YesYesYesYesYesYes
6.0.3xNoNo YesYesYesYesYesYes

OS and Database Version Compatibility Details: 

Below are some of the major points that need to be considered for this plugin :

  • There must be an installation of PostgreSQL on the Staging/Target environment that is compatible with the installation of PostgreSQL on the source environment. Two installations of PostgreSQL are compatible if and only if:

    1. They share the same vendor (for example, PostgreSQL is incompatible with EnterpriseDB Postgres Plus Advanced Server).

    2. They share the same major version number (for example, 9.5.4 is compatible with 9.5, 9.5.3;  however, it is incompatible with 9.3, 9.3.24, or 9.2).

    3. They are compiled against the same architecture (in other words, 32-bit and 64-bit installations of Postgres are incompatible).

    4. They are compiled with the same WAL segment size. The default WAL segment size of 16 MB is rarely changed in practice, so almost all installations of PostgreSQL are compatible with each other in terms of WAL segment size.

  • wal_keep_segments parameter in postgresql.conf file on Source environment should be large enough to support the WAL sync process once the dSource is building up.
  • Any parameter in postgresql.conf  which is related to file location if mentioned on Source Database (for example data_directory,hba_file,ident_file,external_pid_file, etc) then during dSource creation these parameters must also be provided using the custom configuration icon on the UI and the corresponding location should also exist on Staging. The same process applies during the creation of VDB.
Currently, PostgreSQL Plugin 1.4.0 is not supported on SUSE 12.x.


Unsupported PostgreSQL Versions and Features

PostgreSQL versions below 9.4 i.e (9.2, 9.3) are NOT supported by the plugin.

It is not possible to access the staging server with PostgreSQL 9.4 and PostgreSQL 9.5 versions.

Broadly there are two features which are not supported by the plugin:

  • Unlogged Tables: All the tables which are not logged (unlogged) will not be supported by the Plugin.

  • Point In Time recovery: Currently, the Plugin doesn’t support Point in Time recovery of PostgreSQL database.