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 grant the fivetran user the following privileges:

• CREATE: Allows the user to create new schemas in the database
• TEMPORARY: Allows the user to create temporary tables while using the database

GRANT CREATE, TEMPORARY ON DATABASE <database> TO fivetran;