PostgreSQL (Postgres)

Follow this step-by-step guide to connect your PostgreSQL databases to Airbook.

Connecting PostgreSQL Databases

1. Navigate to Connections:

   • In your Airbook workspace, click on the "Connections" tab located on the sidebar.

2. Select PostgreSQL:

   • From the list of available data sources, select "PostgreSQL."

3. Enter Connection Details:

   • You’ll need the following information to connect:

     • Host: The hostname or IP address of your PostgreSQL server.

     • Port: The port number for PostgreSQL.

     • Database Name: The name of the database you want to connect to.

     • Username: Your PostgreSQL username.

     • Password: Your PostgreSQL password.

4. Whitelist Our IP Address:

   • To ensure seamless connectivity and the ability to query your database without interruptions, please whitelist our IP address: 34.122.205.142. This step is crucial for establishing a secure and stable connection between your database and Airbook, allowing us to retrieve and analyze your data effectively. Whitelisting our IP address will help avoid any network or security blocks that could prevent successful data queries.

5. Test Connection:

   • Click the "Submit" button to ensure Airbook can connect to your PostgreSQL database. If the test is successful, you'll see a success message. Otherwise, you'll be prompted to make the required corrections to your database credentials.

6. Save and Connect:

   • Once the connection test is successful, save your configuration. You’ll be prompted to give the connection a schema name. Enter a descriptive name and save it.

7. Start Exploring:

   • Your PostgreSQL database is now connected to Airbook. You can start exploring and analyzing your data.