How to add a PostgreSQL Connector

‍

1. Select Connectors from the left navigation to open the Connectors page.

‍

‍

2. Under Actions, select Add connector.

‍

‍

3. Select the PostgreSQL Connector from the list of connectors.

‍

‍

4. On the Add connector – PostgreSQL page, use the available fields to enter in the appropriate information regarding your PostgreSQL database.

‍

Server – The hostname of the PostgreSQL server. Following the Server name, add a comma and the port the PostgreSQL database listens on. By default, this is port 5432. For example, YourPostgreSQLServer,5432

Database – The name of the PostgreSQL system database.

Username – A PostgreSQL user with read access to the system database.

Password – The password for the PostgreSQL user.

‍

‍

5. After you have entered the information, select Validate under the left Actions menu.

‍

‍

6. After the validation has completed, select Connect.

‍

‍

‍

7. You will be directed to the Select lists page. Check the box to the left of the individual lists to select your lists or you can check Select all to select all the lists from within the PostgreSQL database. After you have selected your lists, select Add lists.

‍

‍

‍

8. You will be taken to the list of your connectors where your PostgreSQL connector will begin installing with the lists you added. After this has completed, your PostgreSQL connector will be available within your list of connectors and available to use.

‍

‍

Having trouble adding this connector? Email support at support@eonesolutions.com