PostgreSQL data sources
Overview
The Delphix PostgreSQL virtualization solution consists of the Delphix Continuous Data Engine and the Connector for PostgreSQL which must be uploaded and installed into the Engine. This solution ingests source data using the staging architecture, which copies (logically or physically, depending on the ingestion method chosen) the production database from the source environment into a staging environment. The Delphix Continuous Data Engine captures the persistent storage layer of the staging database, which then allows the Delphix Continuous Data Engine to create virtualized copies in target environments.
![postgres.png](../../__attachments/131732072/postgres.png?inst-v=9f5cd9ef-94fe-4677-b3c4-6c5d1617af5c)
The PostgreSQL connector supports both staging pull and staging push for data ingestion.
The following specific ingestion methods are supported:
Staging Pull: This ingestion method allows Delphix to execute the necessary operations to prepare the data content in the Staging Environment. Staging pull supports the following ingestion methods:
Delphix-initiated single database backup
PostgreSQL streaming replication with Delphix-initiated Backup
PostgreSQL streaming replication with Externally-initiated backup
Log Shipping with Externally-initiated backup
Staging Push: This ingestion method allows the user to choose and tailor the specific operations and processes to prepare the data content in the Staging Environment.
Limitations of the PostgreSQL solution
The Delphix Continuous Data Engine and the PostgreSQL connector should not be considered a replacement for the backup and recovery of your source instances and databases. The Delphix Continuous Data Engine solution is intended for different purposes, primarily to create non-production database copies.
PostgreSQL will not allow provisioning of a single PostgreSQL vDB filesystem into a pre-existing PostgreSQL cluster. The Delphix solution must create a new PostgreSQL instance and vDB on the target Environment with its own unique HTTP port.
Support
License for the PostgreSQL connector is included with the standard Delphix License Agreement, and Delphix Technical Support backs the solution. For questions, bugs, or feature requests, contact us via the Delphix Support or the Delphix Community portals.