# PostgreSQL

​![](https://859511478-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGDmsjfjJBNqow7Fo97cO%2Fuploads%2FgfNwyVl1VdGAknTACiUM%2Fimage.png?alt=media\&token=47c83b1e-175d-4757-8693-26c4cc11e21b)​

The following set of steps displays how to create a PostgreSQL Data Connector:

* Click the ‘**PostgreSQL**’ Data Connector icon from the Data Connector page.
* The PostgreSQL Data Connector page opens.
* Provide a name for the data connector.
* Describe the data connection.
* Provide the following information:
  * Username
  * Password
  * IP/Host
  * Port
  * Database Name
* **Data Connector Name**: Provide a user-defined name to identify the data connector.
* **Description**: Provide connection details (Optional).
* **Username**: Enter a Username (It should be the same as given in the connection server).
* **Password:** Enter the Password (It should be the same as provided in the connection server).
* **IP/Host**: Enter database server details (from where the user wants to fetch data).
* **Port:** Provide the server port number.
* **Database Name:** Name of the database where you wish to store data.
* **SSL Type**: Select SSL or Non SSL as choices.
* **Upload Key:** Select a upload key using the drop-down menu (This field appears only if the SSL option has been selected for the SSL Type field).
* Click the **Save** option.

<figure><img src="https://content.gitbook.com/content/IctE5LjGWDD6zEdW4vpJ/blobs/2Wk7X22xZa5dCizaMgPA/image.png" alt=""><figcaption></figcaption></figure>

* A success message appears confirming the connection.

  &#x20;    ![](https://859511478-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGDmsjfjJBNqow7Fo97cO%2Fuploads%2FDoZZOwMXX7GM62zZnCI6%2Fimage.png?alt=media\&token=7fbc8ba0-22eb-4733-81c5-89fbde731543)

* A success message appears, and the newly created PostgreSQL data connector gets added to the Data Connectors list..

  &#x20;    ![](https://content.gitbook.com/content/IctE5LjGWDD6zEdW4vpJ/blobs/twXF70ZQc4qJAeVDKw0F/image.png)

{% hint style="info" %}
*<mark style="color:green;">Please Note:</mark>*

* *The PostgreSQL Data Connector supports multiple IP/ Host separated by commas.*
* *The PostgreSQL Data Connector supports **single Port number**.*
* *The **Upload Key** field appears only if the selected SSL Type option is SSL.*
  {% endhint %}