ht
Documentation
WelcomeConcepts

Get Started

OverviewCreate a sourceCreate a modelCreate a destinationCreate a sync

Sources

Amazon AthenaAmazon RedshiftDatabricksGoogle BigQueryGoogle SheetsLookerMySQLPostgreSQLRocksetSnowflakeSQL ServerTrino
Documentation/Sources/PostgreSQL
ht
Documentation

PostgreSQL

Table of Contents
Create the Warehouse connection in Hightouch
PostgreSQL, also known as Postgres, is a free and open-source relational database management system emphasizing extensibility and SQL compliance.

Create the Warehouse connection in Hightouch

Hightouch will always connect to your warehouse from 54.196.30.169 or 52.72.201.213. You may whitelist this IP address in your VPC security groups.
  1. In Hightouch, go to Sources or click https://app.hightouch.io/sources
  2. Click "Create Source"
  3. Select Postgres
  4. Enter your hostname (IP address or EC2 hostname)
  5. For Port, enter your port. This is 5432 by default
  6. For User, enter your Postgres username
  7. For Password, enter your Postgres password
  8. Click "Test" to test the connection. Hightouch is able to successfully connect, click the "Complete" button at the bottom of the page

Tunneling

If your Postgres cluster is not "publicly accessible", you have two options
  • SSH tunnel: Hightouch will connect to your Postgres cluster via an SSH tunnel established from Hightouch's servers to a bastion server in your VPC.
  • Reverse SSH tunnel: You will establish an SSH connection from a bastion server in your VPC to Hightouch's servers, and Hightouch will reuse that connection to connect to Postgres.
Both of these options are now self-serve and can be referenced here.