New features (PostgreSQL)

Release 4.2.3

This plugin release consists of only bug fixes.

Release 4.2.2

This plugin release consists of only bug fixes.

This plugin release includes a bug fix that may not function optimally in certain customer environments. Consequently, access to download this version is restricted in this release. If you need to download this specific version, please reach out to our dedicated Customer Support team for assistance.

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.

This feature requires the plugin to run SQL queries on the datasets. If the plugin cannot login to the dataset for any reason, then source sizing cannot be implemented. For more details about this feature, see Source Sizing Implementation for dSource.

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.