Adding an PostgreSQL environment

This topic describes the process of adding a PostgreSQL staging and target environment.

Prerequisites

To set up a PostgreSQL staging environment, ensure all the essential requirements, as described in Requirements and Prerequisites are met.

Procedure

Perform the following steps to add an environment to the Delphix Continuous Data Engine:

1. Login to the Delphix Management application.

2. Navigate to the Manage > Environments page.

3. Click the Actions ^... menu and select Add Environment.

4. From the Add Environment dialog window, select Unix/Linux.

5. Select Standalone Host.

6. Click Next.

7. Provide the name of the environment.

8. Provide the Host IP address or host FQDN.

9. Provide the SSH port. The default value is 22.

10. Provide an Environment Username for the environment. If you intend to use a low-privileged environment user, ensure that you have fulfilled the Prerequisites for Privilege Elevation using DLPX_DB_EXEC Script.

11. Choose the Login Type that fits your setup. 

    • Username and Password – provide the environment username and password

    • Username and Public Key – provide the environment username 

    • Password Vault – select from an existing Enterprise Password Vault

Using Public Key Authentication
If you want to use public-key authentication for logging into your Unix-based environment, you have two options: 

• Use the Delphix Continuous Data Engine's key pair. For more information on how to use the Delphix Continuous Data Engine's key pair, refer to the How to use the Continuous Data Engine’s key-pair section.

• Provide a key pair for this environment. As an alternative, a key pair specific for this environment can be provided via the API or CLI. For instructions, refer to CLI Cookbook: Setting up SSH key authentication for UNIX environment users. 

12. For Password, enter the password associated with the user in step 11.

13. 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, it must be created.

The addition of the public key is a one-time requirement per user and per environment. Additionally, you have the option to add public key authentication to an environment user's profile via CLI (for details, refer to the CLI Cookbook: Setting up SSH key authentication for UNIX environment users topic).

14. For Password Login, click Verify Credentials to test the username and password.

15. Enter Toolkit Path (ensure that the toolkit path does not have any spaces).

16. To provide your own Oracle Java Development Kit, select the Provide my own JDK checkbox and click Next.

    1. On the Java Development Kit page, provide an absolute path to your Oracle JDK and click Next. 

17. Click Submit.

After successfully adding and discovering the environment, you should be able to view the newly added environment listed under the Environments tab. In case it does not appear, click the refresh icon in your browser.

After the environment has been successfully discovered if you wish to establish further links, add a source configuration to the previously discovered installation.

Perform the following steps to access the information about any environment you have created:

1. Navigate to Manage > Environments.

2. Select the environment name.