Delphix Products

Back to discussions
Expand all | Collapse all

Tip of the Day: Linking a PostgreSQL dSource

  • 1.  Tip of the Day: Linking a PostgreSQL dSource

    Posted 05-23-2014 07:38:00 PM
    1. Log into the Delphix Admin application using Delphix Admin credentials.
    2. Select Manage > Databases > Add dSource.
      Alternatively, on the Environment Management screen, you can click Link next to a database name to start the dSource creation process.
    3. In the Add dSource wizard, select the source database.
    4. Enter your login credentials for DB Cluster User and DB Cluster Password.
    5. Click Advanced to enter a Connection Database.
      The Connection Database will be used when issuing SQL queries from the Delphix Engine to the linked database. It can be any existing database that the DB Cluster User has permission to access.
    6. Click Next.
    7. Select a Database Group for the dSource, and then click Next.
      Adding a dSource to a database group lets you set Delphix Domain user permissions for that database and its objects, such as snapshots. See the topics under Users, Permissions, and Policies for more information.
    8. Select a SnapSync Policy, and, if necessary, a Staging Installation for the dSource.
      The Staging installation represents the PostgreSQL binaries that will be used on the staging target to backup and restore the linked database to a warm standby.
    9. Click Advanced to select whether the data in the data sources is Masked, to select a Retention Policy, and to indicate whether any pre or post scripts should be executed during the dSource creation.
      See Advanced Data Management Settings for dSources and Using Pre- and Post-Scripts with dSources and SQL Server VDBs for more information.
    10. Click Next.
    11. Review the dSource Configuration and Data Management information, and then click Finish.
      The Delphix Engine will initiate two jobs, DB_Link and DB_Sync, to create the dSource. You can monitor these jobs by clicking Active Jobs in the top menu bar, or by selecting System > Event Viewer. When the jobs have successfully completed, the database icon will change to a dSource icon on the Environments > Databases screen, and the dSource will be added to the list of My Databases under its assigned group.