# PostgreSQL

In this page you will learn how to connect **PostgreSQL** to **Erathos** to move your data seamlessly.

The available connections between databases and the Erathos platform are through **Open Connection**, **Static IP** and **SSH tunnel**.

## Connecting PostgreSQL:

1. Log in to your Erathos account
2. Select PostgreSQL as connector
3. Name your connection
4. Fill in the following form with the required information

![](https://help.erathos.com/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBY3M9IiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--411de5481499a1dd55881e7e9888c2f2ec9f7b67/postgresql%20form.png)

On the Advanced config toggle button, you can select which connection you'd like to perform.

![](https://help.erathos.com/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBY0E9IiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--e4aa49f32c9efb5103c03f86e5e613bc8ec655e9/SSH%20MySQL.png)

If you choose to connect through Static IP, you will need to follow the instuction below:

![](https://help.erathos.com/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBZFk9IiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--df86f4129465181563c0c9ec75f60dacddeb2c5a/IP%20Fixo%20Firebire.png)

If you choose to connect through SSH Tunnel, you will need to fill in the additional form below:

![](https://help.erathos.com/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBYzQ9IiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--90a4daeecd55087206a6fb254e3b4fd2093fd82d/ssh%20postregsql.png)

Don't forget to click on **Save and close** to advance to the next steps of the integration.

With this connection created you can seemlessly move your PostgreSQL data to your BigQuery, Redshift or Postgres data-warehouse.