This topic describes how to add a PostgreSQL Staging environment.
Prerequisites
Make sure that the staging environment in question meets the requirements described in Requirements for PostgreSQL Target Hosts and Databases.
Procedure
Login to the Delphix Management application.
Click Manage.
Select Environments.
Next, to Environments, click the Actions (...) menu and select Add Environment.
In the Add Environment dialog, select Unix/Linux.
Select Standalone Host.
Click Next.
Enter Name for the Environment.
Enter the Host IP address or hostname.
Enter the SSH port. The default value is 22.
Enter an OS Username for the Environment which is currently ‘postgres’.
Select Login Type.
For Password, enter the password associated with the user in step 11.
If you want to use Public Key Encryption for logging into your environment:
a. Select Public Key for the Login Type.
b. Click View Public Key.
c. 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.
d. Run chmod 600 authorized_keys to enable read and write privileges for your user.
e. 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.
You can also add public key authentication to an environment user's profile by using the command line interface, as explained in the topic CLI Cookbook: Setting Up SSH Key Authentication for UNIX Environment Users.
For Password Login, click Verify Credentials to test the username and password.
Enter Toolkit Path (make sure Toolkit path does not have spaces).
- To provide your own Oracle Java select the Provide my own JDK checkbox and click Next.
- In the Java Development Kit tab enter the absolute path to your Oracle JDK and click Next. For more information, see Providing Your Own Oracle Java.
Click Submit.
As the new environment is added, you will see two jobs running in the Delphix platform Job History, one to Create and Discover an environment, and another to Create an environment. When the jobs are complete, you will see the new environment added to the list in the Environments tab. If you do not see it, click the Refresh icon in your browser.
18.Once the environment is discovered, further linking would require adding a source config to the above-discovered installation. Please refer to Linking a PostgreSQL dSource for more information.
Post Requirements
To view information about an environment after you have created it:
Click Manage.
Select Environments.
Select the environment name.