New features (PostgreSQL)

PostgreSQL connector DCT parity

PostgreSQL connector UI and API features in Continuous Data are now fully supported in DCT, introduced in DCT 2026.3.0. This release includes support for environment creation, dSource linking, snapshot ingestion, and VDB provisions. We encourage Delphix administrators to install and migrate their day-to-day PostgreSQL connector management to DCT. For more information, see PostgreSQL operations in DCT.

Release 2026.2.0

Virtual-to-Physical (V2P) export

The PostgreSQL connector introduces Virtual-to-Physical (V2P) export support, which lets you export any VDB or dSource snapshot to a standalone physical PostgreSQL host that is independent of Delphix storage. The exported database starts in read-write mode on the target host and retains the same archive mode, configuration, and encryption or TLS state as the source. V2P export is invoked exclusively via the CD Engine API, DCT API or DCT toolkit in this release; there is no DCT UI or Continuous Data Engine UI surface for this workflow.

For more information, see Perform a Virtual-to-Physical (V2P) export on a PostgreSQL dataset in DCT.

Release 2026.1.1

Single database ingestion performance improvement

This enhancement introduces an optional restore optimization that automatically tunes PostgreSQL configuration parameters before each pg_restore run during Single Database Ingestion (SDB). When enabled, the connector computes performance-tuned values for parameters such as shared_buffers, maintenance_work_mem, max_wal_size, max_parallel_workers, and others based on the staging host's available RAM and CPU count, significantly reducing restore time for large databases. The synchronous_commit setting is temporarily set to off during restore to maximize throughput and is automatically reset to on immediately after, ensuring subsequent snapshots and VDBs maintain full durability. All other tuned parameters persist between syncs.

Release 2026.1.0

Support for Hashicorp vault integration for Single Database ingestion

This enhancement introduces Hashicorp vault integration support for the Single Database ingestion workflows when source is hosted as a PaaS database. When the Hashicorp vault is enabled in the Delphix Continuous Data Engine, users can use this vault to provide keys to username and password credentials while creating dsources using the Single Database Ingestion type.

Support for SSL certificates

This release introduces support for SSL certificates to connect to Source database during the Single Database Ingestion workflow. SSL certificates will be used to connect to source PaaS database for data virtualization.

Release 2025.1.0

Microsoft Azure Entra authentication support

This enhancement introduces Microsoft Azure Entra authentication integration for the Single Database Ingestion workflows when the source is an Azure Flexible PostgreSQL Server. This enterprise-grade authentication method provides enhanced security and seamless integration with Azure-based PostgreSQL deployments.

Enhanced parallel index restoration for the Single Database Ingestion workflow

This enhancement optimizes the Single Database Ingestion workflow by implementing a two-phase restoration process that enables parallel index creation, significantly improving performance for large database restorations.

Simplified privilege elevation

This enhancement streamlines the Privilege Elevation requirements, making deployment easier while maintaining security best practices.

Target clone database name support

This enhancement introduces a new Target Clone Database Name optional field to the Single Database Ingestion workflow, providing greater flexibility in database renaming conventions during linking/ingestion.

Release 4.3.2

Additional certifications supported

• Certification has been made available for PostgreSQL v16.x to 12.x on Ubuntu 22.04.

• Certification has been added for PostgreSQL v16.x on RHEL v8.5.

Release 4.3.1

This plugin release consists of only bug fixes.

Release 4.3.0

This plugin release allows you to provision a VDB in Kubernetes using an existing dSource. Provisions are completed through the K8s Driver integration. For more information, link a source using this documentation set and then refer to the K8s Driver documentation to provision.

Release 4.2.3

This plugin release consists of only bug fixes.

Release 4.2.2

This plugin release consists of only bug fixes.

Release 4.2.1

This plugin release consists of only bug fixes.

Release 4.2.0

This plugin release has the following set of new features.

• Auto Roll Forward Optional
  
  With PostgreSQL Plugin 4.2.0 and onwards, the plugin will apply the latest wal logs copied to the wal log path only when the snapshot button clicks from UI. For more information, refer to Creating a dSource with external backups using WAL Logs.

• Ubuntu 18.04 with Postgres 15 certification
  
  This release certifies Ubuntu 18.04 with Postgres 15.

Release 4.1.1

This plugin release consists of only bug fixes.

Release 4.1.0

This plugin release has the following set of new features.

• Source sizing for dSource with ZFS
  
  With PostgreSQL Plugin 4.1.0 and onwards, dSource database size will be calculated using du command on dSource mount path. For more information, see Source sizing implementation for dSource.

• Azure Database for PostgreSQL - Flexible Server Certification
  
  Added support for the PaaS-to-IaaS ingestion model of Azure Flexible Server 11, 12, 13, and 14 versions.

Release 4.0.0

This plugin release has the following set of new features.

• Provisioning a PostgreSQL VDB PiT with external logs
  
  With the latest PostgreSQL Plugin 4.0.0 and onwards, you can provision a VDB to a point in time by providing the WAL logs on the target host. For detailed information, see Provisioning a PostgreSQL VDB PiT with External Logs.

• pg_dumpall support for single database ingestion
  
  PostgreSQL plugin 4.0.0, supports pg_dumpall which has been added with Single Database Ingestion to get the global objects like roles and tablespaces.

Release 3.2.0

This plugin release has the following set of new features.

• Enhancement to the external backup mechanism
  
  With the 3.2.0 release, while using External Backup Mechanism it is now not mandatory for you to provide the backups as ZIP files. This enhancement thus removes the mandatory requirement of pg_basebackup to be encapsulated in PostgreSQL_T<YYYYMMDD>.zip format. You can now store the backups (as tars) on the staging server directly, without providing the backups as ZIP files (reducing the time spent on creating ZIP files) using the following additional ways:

  • Within folders (named PostgreSQL_T<YYYYMMDDhhmmss>) created inside the provided backup path. 

  • Within the provided backup path - PostgreSQL Backup File Path

  Switching to the new mechanism is easy, just store the full backup within the same backup path and run a resync operation.

  The plugin still supports the usage of zip files.

• Introducing a LOG_LEVEL parameter in the PostgreSQL plugin configuration
  
  PostgreSQL plugin supports remote side logging, with all plugin logs available within the scratch path on the remote host (<tookit_path>/Delphix_COMMON_*/plugin/postgres-vsdk_*). You can tweak the log parameters related to log rotation within the plugin configuration file called dlpx_postgres_config.ini. The 3.2.0 version, introduces a new parameter called LOG_LEVEL, with the capability of handling the amount of logs being generated on the remote host. Accepted values are DEBUG, INFO, WARNING, and ERROR, with INFO being the default value.

Release 3.1.0

This plugin release has the following set of new features.

• Source sizing implementation on PostgreSQL plugin
  
  This feature enables you to check the size of PostgreSQL cluster or database being virtualized from the Delphix Engine. The calculation of the dataset size is based on the ingestion method used. For staging pull methods, if the whole cluster is ingested then the size of the cluster will be calculated or else the size of the ingested single database will be calculated. Source sizing cannot be implemented when staging push method is used.

Release 3.0.0

This plugin release has the following set of new features.

• Staging push
  
  The PostgreSQL Plugin 3.0.0 release introduces a new data ingestion mechanism i.e. Staging Push that enables you to push data into the Delphix-provided mount point on your own. It is an alternative Delphix dSource data ingestion approach that enables you to push the data in Delphix, which is different from the conventional pull model where Delphix pulls the data.

  Delphix relinquishes the responsibility to prepare the data (ie: recover to a specific state) on the staging push. It is different from conventional staging where Delphix controls the state of recovery of the staging database.

  There are two mechanisms to create dSource on the staging server.

  • Pull architecture: The Postgres plugin pulls the data into the Delphix-provided mount location.

  • Staging Push architecture: You push the data into the Delphix-provided mount point on your own.

  For more details, see Staging Push Implementation.

Release 2.1.1

This plugin release consists of only bug fixes.

Release 2.1.0

This plugin release has the following set of new features.

• Privilege elevation
  
  The Privilege Elevation feature allows you to use a low privileged OS user to create a dSource or VDB. To use this feature, you must provide a username in the Privileged OS account (optional) field on the dSource creation page. The plugin will then use the dlpx_db_exec script to perform the privilege elevation. The script has to be updated via the engine API before the creation/discovery of an environment.

Release 2.0.0

The PostgreSQL Plugin version 2.0.0 includes the following improvements and features:

• Plugin generated log file will now be placed at <toolkit path>/Delphix_COMMON_<long id>/plugin/postgres-vsdk_12c9a11f-fab6-4792-a5da-49d726c004df/<os user> instead of <toolkit path>/postgres/logs.

• Improved logging

• The plugin logs will be part of the support bundle.

• The plugin logs will be available on the target host as well as on the Delphix Engine host.

• Introduction of a new generic config ini file dlpx_postgres_config.ini which will be present at the scratch path. The previous log configure file dlpx_pg_logrotate.conf will no longer be available and the contents of this file will be moved to the generic config ini file-dlpx_postgres_config.ini.

• The PostgreSQL plugin will now have one more ingestion mechanism - Single Database Ingestion that allows you to virtualize a single database.

Release 1.5.1

This release includes the Streaming Replication Monitoring feature that monitors the streaming replication by reading the Postgres database logs every minute.

Release 1.5.0

This plugin release consists of only bug fixes.

Release 1.4.4

This plugin release consists of only bug fixes.

Release 1.4.3

This plugin release consists of only bug fixes.

Release 1.4.2

This plugin release consists of only bug fixes.

Release 1.4.1

This plugin release consists of only bug fixes.

Release 1.4.0

PostgreSQL Plugin version 1.4.0 contains the following certifications :

• Operating System - RHEL/CentOS 7.8 version Support with PostgreSQL 12.x.