Skip to main content
Skip table of contents

New features (PostgreSQL)

Release 3.2.0

This plugin release has the following set of new features.

  • Enhancement to 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.

If you are using privilege elevation and upgrading to PostgreSQL 3.1.0 version, then you will have to change the sudoers entry. For more details see, Prerequisites for Privilege Elevation using DLPX_DB_EXEC Script.

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.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.