Generic PostgreSQL Warehouse Setup Guidelink
Allow accesslink
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
- Incoming connections to your Postgres port (usually
Create userlink
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;