Postgres Support Matrix

RHEL/CentOS/SUSE 

where x represents the minor version.

Note: 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:

OS and Database Version Compatibility Details: 

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

• Compatible Operating System supported by the Plugin is CentOS 7.3/7.4/7.5/7.6 , RHEL 7.3/7.4/7.5/7.6 and SUSE 11/12. The underlying Operating System for Source, Staging and Target environment should be amongst these versions and identical OS is to be installed on Source and Staging environment. 

• 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.

Unsupported PostgreSQL Versions and Features