# Connecting to a PostgreSQL cloud SQL instance

### **Prerequisites**

Ensure that you have an existing GCP Cloud PostgreSQL instance.

### **Steps to follow**

1. Go to [this link](http://console.cloud.google.com/sql/instances) where the list of instances will be displayed.
2. Select the required instance from the existing list.
3. If you do not have an existing instance, click on **Create Instance** to create one.
4. On the **Create an instance** page, choose PostgreSQL database engine from the list.

<figure><img src="https://content.gitbook.com/content/s16h5onryWtbaHwBa10b/blobs/8pJvfyrKXl1F8V0qREiR/image.png" alt=""><figcaption><p>Creating an instance</p></figcaption></figure>

5. In the **Primary Instance** pane on the left side, select **Connections** and click on the **Networking** tab.
6. Under **Instance IP assignment**, click on the **Public IP** checkbox.

<figure><img src="https://content.gitbook.com/content/s16h5onryWtbaHwBa10b/blobs/aM6Ex6NwBWc38pbPkZe3/image.png" alt="" width="563"><figcaption><p>Selecting Public IP</p></figcaption></figure>

7. Click on **Add a network** under the **Authorized networks** section. **New network** section will open.

<figure><img src="https://content.gitbook.com/content/s16h5onryWtbaHwBa10b/blobs/NOxg1cBoy6n67MqLpLph/image.png" alt="" width="563"><figcaption><p>Adding a new network</p></figcaption></figure>

8. Provide a **Name** and **IP address** in the respective fields. Click on **Done** and click on **Save**.

{% hint style="info" %}
Please note that the IP address in CIDR notation will be provided by the Tellius team.&#x20;
{% endhint %}

9. Under the **Security** tab, ensure that the checkbox **Allow only SSL connections** is left unchecked.

<figure><img src="https://content.gitbook.com/content/s16h5onryWtbaHwBa10b/blobs/3bWQiTqQUTuIEJ40nG4U/image.png" alt="" width="563"><figcaption><p>Unchecking "SSL connections"</p></figcaption></figure>

{% hint style="info" %}
If *Only secured connections are allowed to connect to this instance* is displayed, click on **Allow unsecured connections**.\
\
If *Unsecured connections are allowed to connect to this instance* is displayed, you do not need to change anything.
{% endhint %}

10. From the GCP console, please note the following details, as they will be required when setting up the connection on the Tellius platform:

    * Under the **Summary** tab, copy the Public IP address.

    <figure><img src="https://content.gitbook.com/content/s16h5onryWtbaHwBa10b/blobs/P53YkAH2sftstwD89wV7/image.png" alt=""><figcaption><p>Copying the public IP address</p></figcaption></figure>

    * In the **Primary Instance** pane, select **Databases**. From the list of databases, copy the name of the required database.
    * In the **Primary Instance** pane, select **Users**. From the list of users, copy the name of the required user.
11. In the Tellius platform, navigate to **Data → Connect → Create New → PostgreSQL**.

<figure><img src="https://content.gitbook.com/content/s16h5onryWtbaHwBa10b/blobs/OMYhhQpX7Yry7ununnFr/image.png" alt="" width="563"><figcaption><p>Data → Connect → Create New → PostgreSQL</p></figcaption></figure>

12. Paste the IP address in the **Hostname** field.
13. Provide the default port number 5432 in the **Port** field.
14. Paste the copied database name in the **Database** field.
15. Paste the copied user name in the **User** field.
16. Provide the required password in the **Password** field.
17. Click on **Save and Browse Host** (or **Browse Host** if you are using an already established connection). The list of tables from the data source will be displayed on the right side.

<figure><img src="https://content.gitbook.com/content/s16h5onryWtbaHwBa10b/blobs/CtiR8htQrj5YHerro6YN/image.png" alt="" width="563"><figcaption><p>After establishing a connection</p></figcaption></figure>
