Features

PostgreSQL toolkit version 1.1.0 contains the following new features :

  1. PostgreSQL 9.4.x and PostgreSQL 11.x version support.

  2. External Backup Ingestion with Streaming Replication for sync between Source and dSource.

  3. External Backup Ingestion with WAL files for sync between Source and dSource.

  4. Delphix initiated backup with Streaming Replication for sync between Source and dSource.

  5. Kerberos Support.

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 - PostgreSQL Standard Versions


Supported DBMS Version

PostgreSQL

9.4.x

PostgreSQL

9.5.x

PostgreSQL

9.6.x

PostgreSQL

10.x

PostgreSQL

11.x


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

where x is the minor version of the PostgreSQL Database.

RHEL/CentOS - EDB PostgreSQL Versions


Supported DBMS Version

EDB

PostgreSQL

9.4.x

EDB

PostgreSQL

9.5.x

EDB

PostgreSQL

9.6.x

EDB

PostgreSQL

10.x

EDB

PostgreSQL

11.x


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

where x is the minor version of the PostgreSQL Database.

Toolkit/Delphix Engine Compatibility

Toolkits 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
5.3.1.xYesYesNo
5.3.2.xYesYesNo
5.3.3.xNoNoYes


Toolkit Upgrade Path

Path A - New toolkit installation for PostgreSQL customers:

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

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

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

Path B - Existing PostgreSQL customers with different toolkit version:

For PostgreSQL customers with toolkit version 1.0.1 or 1.0.2

  • Interested in External Backups feature:

    • Toolkit upgrade path: 1.0.1 → 1.1.0

    • Toolkit upgrade path: 1.0.2 → 1.1.0

Note: In order to upgrade the existing objects with 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 was 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 Toolkit.

  • Point In Time recovery: Currently, the toolkit doesn’t support Point in Time recovery of PostgreSQL database

Fixed Issues

PostgreSQL version 1.1.0 contains the following bug fixes:

KeySummaryNotes
POST-173Linking a 9.5 Postgres instance fails if the source is in wal_level = archive.


POST-176 Validate connectivity check does not use the defined replication user.