PostgreSQL virtualization process
The following material introduces you to the overall process of deploying the PostgreSQL virtualization solution. A sequence of high-level steps is presented; each step briefly describes the task and the expected result. Refer to the embedded links for more detailed information.
Begin by reviewing the general Delphix Continuous Data Engine architecture diagrams. Identify existing or new PostgreSQL source, staging, and target Environments, the underlying Operating Systems, and PostgreSQL database versions. This will give a good understanding of the architectural strategy and confirm support.
Review the PostgreSQL Support Matrix. Confirm that your combination of PostgreSQL software, host operating system, Delphix Engine version, and PostgreSQL connector version are supported for the various environments which will integrate into your PostgreSQL deployment. Early validation will reduce unexpected issues later.
Deploy and configure Delphix Continuous Data.
Install the PostgreSQL connector. The PostgreSQL connector extends the Delphix Continuous Data Engine to PostgreSQL datasets. It is recommended to stay current with the latest version of the connector.
Create staging and target environments. Create the staging and target hosts and ensure that they are running and reachable. Follow the host requirements to configure the respective environments. The staging environment will host a PostgreSQL instance that the Delphix Continuous Data Engine will ingest from. The target environment will host one or more PostgreSQL instance(s) in which the virtual database copies will be created.
Consult the source environment and staging/target environment requirements documentation for configuration details.
Add Staging and Target Environments in the Delphix Continuous Data Engine. Use the "Add Environment" operation in Delphix Continuous Data Engine for each host, which causes Delphix to register the specific host and catalog the PostgreSQL software installation(s) on that host.
Link the PostgreSQL source database. Configure and create a dSource which allows the Delphix Continuous Data Engine to capture a copy of the source data. There are many ingestion methods that can offer a variety of methods to capture the data to be virtualized by Delphix. Therefore, we encourage you to identify the ingestion method that best suits your organization and infrastructure policies.
Provision virtual PostgreSQL databases. Administrators and users can provision multiple copies of the source data as virtual databases.