PostgreSQL installation and upgrade

The PostgreSQL connector is managed through the Delphix Continuous Data Engine’s plugin framework. Plugins are distributed separately from the engine. The plugin must be installed before PostgreSQL Environments can be added, and before attempting any PostgreSQL virtualization operations.

Downloading the connector 

Perform the following steps to download the PostgreSQL connector to your Desktop system.

1. Log in to the Delphix Download Portal using your credentials from the Delphix Support Portal.

2. Find the PostgreSQL plugin folder by navigating to the “Delphix Product Releases / Continuous Data Connectors / PostgreSQL” path and selecting the desired version’s folder.

3. Download the .zip plugin file by clicking "Plugin_postgreSQL_<version>.zip”.

4. After the download is complete, extract the contents of the downloaded .zip file to obtain a JSON file. For example, postgres.json.

Installing the connector

Perform the following steps to upload and install a new connector.

1. Log in to the Delphix Management application.

2. Navigate to the Manage > Plugins page.

3. To upload a plugin, click the plus icon. This action displays a "Upload or Upgrade a Plugin" dialog window.  

4. Browse to the JSON  file on your desktop which you downloaded and extracted in the previous step

5. Upload the downloaded JSON (for example, postgres.json) file.

   

For more information, refer to the Delphix Continuous Data Engine connector management section.

Upgrading the connector

The connector must be upgraded to a specific version in order to accommodate new features and bug fixes that can affect its configuration. If the existing connector version is particularly old, connector upgrades may also require Delphix Continuous Data Engine upgrades. 

Skipping a recommended version upgrade path may lead to configuration issues.

Perform the following steps alongside the upgrade path to ensure your configuration remains compatible with minimal disruption.

Standard upgrade process

Perform the following steps when you are upgrading to connector versions 2.0.0 and later.

1. Upload the connector with the higher version. For more information, refer to the Installing the PostgreSQL connector documentation.

2. Refresh all relevant environments associated with this connector.

3. Verify that the connector discovery process has been completed successfully.

4. Create fresh snapshots of both the dSource and VDB.

   • To confirm the new snapshots were taken successfully with the new connector versions, review the snapshot metadata on the new snapshot.

     

Starting with version 2.0.0, datasets, including dSources and VDBs, do not require a disable and re-enabled as part of the upgrade process.

Upgrade process for connector version before 2.0.0

Perform the following steps when you are upgrading to connector versions before 2.0.0.

1. Disable all the datasets, including both dSources and VDBs.

2. Upload the connector with the higher version. For more information, refer to the Installing the PostgreSQL connector documentation.

3. Refresh all the environments associated with it and verify that the connector discovery is completed successfully.

4. Re-enable all the datasets.

5. Create fresh snapshots of both the dSource and VDB.

Upgrade path