Features

PostgreSQL plugin version 1.0.2 contains the following features in addition to the bug fixes which has been described in the next section:

  1. Flexibility for customers to change/edit any number of parameters in PostgreSQL Configuration file (while creating dsource and VDB) directly from UI.

  2. Support for PostgreSQL Tablespaces.

  3. Supports Streaming Replication.

Support Matrix

Supported Versions

PostgreSQL Standard Versions:

  • PostgreSQL 9.5

  • PostgreSQL 9.6

  • PostgreSQL 10

PostgreSQL EDB Versions:

  • PostgreSQL 9.5

  • PostgreSQL 9.6

  • PostgreSQL 10

Supported Operating Systems

RHEL/CentOS  


Supported DBMS Version

PostgreSQL

9.5

EDB

PostgreSQL

9.5

PostgreSQL

9.6

EDB

PostgreSQL

9.6

PostgreSQL

10

EDB

PostgreSQL

10


Supported OS Version
RHEL/CentOS 7.3SupportedSupportedSupportedSupportedSupportedSupported
RHEL/CentOS 7.4SupportedSupportedSupportedSupportedSupportedSupported

Plugin/Delphix Engine Compatibility

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

Delphix Engine
PostgreSQL_1.0.1
PostgreSQL_1.0.2
5.3.1.xYesYes
5.3.2.xYesYes

Unsupported PostgreSQL Versions and Features

  • PostgreSQL versions below 9.5 i.e 9.2, 9.3 and 9.4 (including the minor versions) are not supported.

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

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

Fixed Issues

PostgreSQL version 1.0.2 contains the following bug fix:

KeySummaryNotes
POST-119PostgreSQL discovery uses 'find' which can impact discovery performance.

In order to optimize the performance, it is preferred to create an Environment Variable "DELPHIX_PG_PATH" which should be accessible by OS user

Below should be the syntax for  "DELPHIX_PG_PATH" variable:

DELPHIX_PG_PATH="binary_path:data_path1;binary_path:data_path2;"

For example:

DELPHIX_PG_PATH=/usr/pgsql-9.6/bin:/var/lib/pgsql/9.6/data;/opt/edb/as9.6/bin:/opt/edb/as9.6/data;/usr/pgsql-9.6/bin:/tmp/TESING/data;

In the absence of  "DELPHIX_PG_PATH" variable or if value of  "DELPHIX_PG_PATH" variable is NULL then Linux "find" command will be used for Environment discovery which may impact the overall performance. Hence, it is preferred to create this Environment Variable with correct entries.

POST-127VDB is taken down during snapshot.
POST-128Environment Discovery.
POST-137Postgres plugin logs should not be stored in /tmp.
POST-152Port check for stopping VDB and Staging not specific enough.
POST-149Port usage error during VDB refresh.

Known Issues

KeySummaryWorkaround
POST-68The user is able to add dsource from an existing dsource.