All PostgreSQL Delphix operations such as linking, snapshot, and provisioning always occur on the database level. As a result, it is required that any PostgreSQL instance that is to be used either as Staging or Target must have its associated instance owner added as an environment user to the host within Delphix. Steps to add OS environment user on the host:

(It is important to note that Delphix will not create new instances on the host and can only use existing PostgreSQL instances that it finds on the host machine.)


  1. Login to the Delphix Management application.

  2. Click Manage.

  3. Select Environments.

  4. Click on the existing environment name you want to modify and open the environment information screen.

  5. In the Details tab, click the Plus icon located next to Environment users.

  6. Enter the Username and Password for the OS user in that environment.

    Using Public Key Encryption -- For Unix-Based Environments

    If you want to use public key encryption for logging into your environment:

    1. Select Public Key for the Login Type.

    2. Click View Public Key.

    3. Copy the public key that is displayed, and append it to the end of your ~/.ssh/authorized_keys file. If this file does not exist, you will need to create it.

    1. Run chmod 600 authorized_keys to enable read and write privileges for your user.

    2. Run chmod 755 ~ to make your home directory writable only by your user.

    The public key needs to be added only once per user and per environment.

  7. Click the Check icon to save the new user.

  8. To change the primary user for this environment, click the Pencil icon next to Environment Users. Only the primary user will be used for environment discovery.

  9. To delete a user, click the Trash icon next to their username.