# PostgreSQL

## 1. How to connect to PostgreSQL?

Acho allows you to connect to any PostgreSQL database (Self-hosted, GCP Cloud SQL, AWS PostgreSQL, AWS Aurora...). You can follow the steps below to set up the connection.

1\. Go to the **Resources** page and click the **Add Resource** button.

2\. In the "Select a data source" step, select **PostgreSQL** under the **Database** tab.

3\. In the "Configure the data source" step, enter your database login credentials.

* `host`: either a `hostname` or an `IP address` depending on where you host your PostgreSQL database
* `port`
* `DB Name`
* `User`
* `Password`

{% hint style="info" %}
 Note: remember to add Acho's IP address, **`35.239.14.244`**, to your [whitelist](#3.-how-to-add-achos-ip-into-your-whitelist) before starting the connection.
{% endhint %}

4\. In the "Select the tables", choose tables that you want to import.

5\. Click **Finish Setup**. You will see a  <img src="/files/-MgBo4LSmdK4OS-NqLZy" alt="" data-size="line"> icon next to your PostgreSQL resource. It may take a few minutes to several hours depending on the data size and the number of your tables. Once your APP's data is ready, you will receive a notification email.&#x20;

## 2. How to set up Data Sync?

Acho supports creating schedulers to retrieve the latest data from your database at a certain time interval. To see more details, you can visit [here](https://docs.acho.io/data-sync/untitled).

## 3. How to add Acho's IP into your whitelist?

You should whitelist our service IP address **`35.239.14.244`** . This way we can make a connection to your database and import the tables to **Acho Studio**. Here is how you can whitelist Acho's service IP address for your database instance.

### **Example 1: Whitelist for Cloud SQL on GCP (Google Cloud Platform)**

1. Click on your database instance and then navigate to the **Connections** page
2. Check the **Public IP** checkbox.
3. Click **Add network** , and enter **`35.239.14.244`**(If you need to input an IP range, just enter **`35.239.14.244`**).
4. Click **Done** and **Save**.

![](/files/-Mjpph5hGYz6hmAUW6k8)

### **Example 2: Whitelist for RDS or MySQL on AWS (Amazon Web Services)**

1\. Go to **Network & Securtiy** and make sure your database instance can connect to our service as shown below.

![img](https://gblobscdn.gitbook.com/assets%2F-MB_fx7PCUqvFEdrucJC%2F-MHEB0JPVdUtjpRlAtjx%2F-MHHX-TM9Aia1h5yd6Vb%2FScreen%20Shot%202020-09-15%20at%2011.44.15%20AM.png?alt=media\&token=f5619f9c-5b7e-4b94-a146-2a691fc5649d)

2\. Click on the **Security Groups** and add an **Inbound Rule** to allow our service to connect to your database as shown below.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.acho.io/acho-studio/resources/import-data/postgresql.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.