Linking Postgres as a source

The Postgres connector can link your database tables to PostHog.

To link Postgres:

1. Go to the data warehouse tab in PostHog
2. Click Link Source and select Postgres
3. Enter your database connection details:
   • Host: The hostname or IP your database server like db.example.com or 192.168.1.100.
   • Port: The port your database server is listening to. The default is 5432.
   • Database: The name of the database you want like analytics_db.
   • User: The username with the necessary permissions to access the database.
   • Password: The password for the user.
   • Schema: The schema for your database where your tables are located. The default is public.
4. Click Link

The data warehouse then starts syncing your Postgres data. You can see details and progress in the data warehouse settings tab.

Looking for an example of the Postgres source? Check out our tutorial where we connect and query Supabase data.

Inbound IP addresses

We use a set of IP addresses to access your Postgres instance. To ensure this connector works, add these IPs to your inbound security rules to enable the data import: