You can take a new snapshot of the dSource by clicking the Camera icon on the dSource card. Once the snapshot is complete you can provision a new VDB from it. This topic describes how to provision a virtual database (VDB) from a POSTGRES dSource.

Prerequisites


You can take a new snapshot of the dSource by clicking the Camera icon on the dSource card. Once the snapshot is complete you can provision a new VDB from it


Procedure

  1. Login to the Delphix Management application.

  2. Click Manage.

  3. Select Datasets.

  4. Select a dSource.

  5. Select a snapshot from which you want to provision.

  6. Click Provision VDB icon to open Provision VDB wizard.

  7. Select a target environment from the left pane.

  8. Select an Installation to use from the dropdown list of available Postgres instances on that environment.

  9. Set the Environment User to be the Instance Owner. Note: The picking of instance owner is only possible if you have multiple environment users set on that host.

  10. You will see Target Configuration section where you need to specify Mount Path and Virtual Postgres Port Number.


  11. Optionally, set the database configuration parameters for the VDB.

  12. Click Next.

  13. In the configuration section provide vFiles Name as database name as the parameter.

  14. Select a Target Group for the VDB and lick the green Plus icon to add a new group, if necessary.

  15. Select a Snapshot Policy for the VDB.

  16. Click Next.

  17. Specify any desired hook operations. For details about hook operations, refer to Customizing PostgreSQL Management with Hook Operations.

  18. Click Next.

  19. Review the Provisioning Configuration and Data Management information.

  20. Click Submit.
    When provisioning starts, you can review the progress of the job in the Databases panel, or in the Job History panel of the Dashboard. When provisioning is complete, the VDB will be included in the group you designated and listed in the Databases panel. If you select the VDB in the Databases panel and click the Open icon, you can view its card, which contains information about the database and its Data Management settings.
    Once the VDB provisioning has successfully completed, if the source and target instance ids are not the same, you may want to grant secadm and dbadm on the database to the target instance id. Please refer to Database Permissions for Provisioned PostgreSQL VDBs for more information.