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)


Supported OS Version
RHEL/CentOS 7.3SupportedSupportedSupportedSupportedSupported
RHEL/CentOS 7.4SupportedSupportedSupportedSupportedSupported
RHEL/CentOS 7.5SupportedSupportedSupportedSupportedSupported
RHEL/CentOS 7.6SupportedSupportedSupportedSupportedSupported
SUSE 11.xSupportedNot SupportedNot SupportedNot SupportedNot Supported
SUSE 12.x SupportedSupportedSupportedSupportedSupported

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:

Delphix Engine
Versions
Plugin Versions
PostgreSQL_1.0.1
PostgreSQL_1.0.2
PostgreSQL_1.1.0PostgreSQL_1.2.0
5.3.1.xYesYesNoNo
5.3.2.xYesYesNoNo
5.3.3.xNoNoYesYes
5.3.4.xNoNoYesYes
5.3.5.xNoNoYesYes

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

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