Features

PostgreSQL Plugin version 1.2.0 contains the following certifications :

  1. Operating System - SLES 11 and SLES 12 Support.

  2. Operating System - RHEL/CentOS 7.5 and  7.6 version Support in addition to previous supported RHEL/CentOS versions.

Migration and Compatibility

Supported Versions

PostgreSQL Standard Versions:

  • PostgreSQL 9.4.x

  • PostgreSQL 9.5.x

  • PostgreSQL 9.6.x

  • PostgreSQL 10.x

  • PostgreSQL 11.x

PostgreSQL EDB Versions:

  • PostgreSQL 9.4.x

  • PostgreSQL 9.5.x

  • PostgreSQL 9.6.x

  • PostgreSQL 10.x

  • PostgreSQL 11.x

Supported Operating Systems

RHEL/CentOS/SLES - PostgreSQL Open Source & EDB


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
SLES 11SupportedNot SupportedNot SupportedNot SupportedNot Supported
SLES 12SupportedSupportedSupportedSupportedSupported

where x is the minor version of the PostgreSQL Database.

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

PostgreSQL 1.1.0

PostgreSQL 1.2.0

5.3.1.xYesYesNoNo
5.3.2.xYesYesNoNo
5.3.3.xNoNoYesYes
5.3.4.xNoNoYesYes
5.3.5.xNoNoYesYes


Plugin Upgrade Path

Path A - New Plugin installation for PostgreSQL customers:

  • Upload 1.0.1 Plugin for PostgreSQL 9.5.x, 9.6.x and 10.x customers

  • Upload 1.0.2 Plugin for PostgreSQL 9.5.x, 9.6.x and 10.x customers

  • Upload 1.1.0 Plugin for PostgreSQL 9.4.x, 9.5.x, 9.6.x,10.x and 11.x customers

  • Upload 1.2.0 Plugin for PostgreSQL 9.4.x, 9.5.x, 9.6.x,10.x and 11.x customers

Path B - Existing PostgreSQL customers with different Plugin version:

For PostgreSQL customers with Plugin version 1.0.1 or 1.0.2

  • Interested in External Backups feature:

    • Plugin upgrade path: 1.0.1 → 1.1.0 → 1.2.0

    • Plugin upgrade path: 1.0.2 → 1.1.0 → 1.2.0

For PostgreSQL customers with Plugin version 1.1.0

  • Plugin upgrade path: 1.1.0 → 1.2.0

Note: In order to upgrade the existing objects with 1.1.0 (i.e 1.0.1 → 1.1.0 or 1.0.2 → 1.1.0), just after upgrade it is mandatory to update below two parameters of dSource using "custom Configuration" option on the UI :

  • Source IP Address
  • Source Port

A critical fault will show up on dSource just after the upgrade. It is because the engine is not able to find the source config from which dSource was created. As we have moved to manual

discovery in this release, we need to mark this fault as resolve on the status tab of dSource.

Unsupported PostgreSQL Versions and Features

  • PostgreSQL versions below 9.4 i.e 9.2, 9.3  (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, the Plugin doesn’t support Point in Time recovery of PostgreSQL database

Fixed Issues

PostgreSQL version 1.2.0 contains the following bug fixes:

Key

Summary

Notes

POST-207Update custom config should check for 'Property Value' in postgresql.conf


POST-216Linking script doesn't error out with faulty input
POST-163Improve Diagnosability in Postgres Plugin
POST-210The term Pretty Name needs to be removed from the UI.