How to connect Postgres to Adriel

Detailed instructions to help you set up the data source for Postgres

Lastly modified on: Thu, 20th June, 2024 at 03:47 PM

Prerequisites

• Postgres database
• Postgres user with a read right
• Postgres user allowed to connect remotely to the database from the IP address: 79.160.224.

Instructions

1. Move to Adriel’s Connections page.
2. Type “Postgres” into the search bar.
3. Fill in the required and optional fields accordingly to the database that you want to connect to Adriel.
   - (Required)Host: Database hostname
   

   If your database is hosted behind a firewall, whitelist the following IP address: 52.79.160.224.

   - (Required)Database: Name of the database that you want to import.
   - (Required)User: Name of a user with a read access to your database
   - (Required)Password: Password of the Postgres user
   - (Optional)Port: Database port; default port of Postgres is 3306.
   
   - (Optional)Alternative Channel Name: Alternative name for the data source
   - No icon is provided as a default for this feature. However, there are channels that can use internally saved icons and display next to the channel name you just wrote down. 
   
   - Refer to this guide to input the correct name to display the icon. 
   https://academy.adriel.com/en/how-to-set-alternative-channel-name-for-file-db-data-source
   
   
4. Click the “Submit” button below to complete the data connection.
   
   It can take up to one working day for your data to arrive.