Postgres

​

Prerequisites

To connect Postgres to Push.ai, you need the following:

• A Postgres account with the appropriate permissions to create a user.

​

Setup Guide

​

Step 1 - Create the warehouse connection

1. Log in to your Postgres database.

2. Create a user with read permissions to the schema and tables that you want to connect from.

3. If data will be written back to the warehouse from Push.ai, add a schema and permissions to allow the Push.ai user to write to a specific schema.

​

Step 2 - Whitelist IP Addresses (if necessary)

Push.ai connects to your warehouse from the following IP addresses. Be sure to allow traffic from these IPs in your firewall, and include them in any database grants.

​

Step 3 - Configure the connection in Push.ai

1. Add the Host, Port, Database, Username, Password

2. (Optional) Configure the schema name to write to. By default, data will be written to PUSH_AI.

3. Click Test Postgres to confirm the connection settings.

4. Click Connect Postgres to complete the connection.