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|
|SUSE 11.x||Supported||Not Supported||Not Supported||Not Supported||Not Supported|
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:
They share the same vendor (for example, PostgreSQL is incompatible with EnterpriseDB Postgres Plus Advanced Server).
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).
They are compiled against the same architecture (in other words, 32-bit and 64-bit installations of Postgres are incompatible).
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.
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.