Generic PostgreSQL Warehouse Setup Guide

Allow access

Decide whether to connect to your warehouse directly or connect using an SSH tunnel.

• To connect using an SSH tunnel, follow these instructions.
• To connect directly, configure your firewall and/or other access control systems to allow:
  • Incoming connections to your Postgres port (usually 5432) from Fivetran's IP
  • Outgoing connections to all ports (1024 to 65535) at Fivetran's IP

---

Create user

Connect to your Postgres warehouse and run the following query to create a password:

CREATE USER fivetran PASSWORD <password>;

Run the following query to allow the fivetran user to create schemas:

GRANT CREATE ON DATABASE <database> TO fivetran;