Linking Postgres as a source

The Postgres connector can link your database tables to PostHog.

To link Postgres:

1. Go to the Data pipeline page and the sources tab in PostHog
2. Click New source and select Postgres
3. Enter your database connection details:
   • Host: The hostname or IP your database server like db.example.com or 123.132.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: (Optional) The schema for your database. Leave blank to browse and sync tables from all schemas, or specify one to limit the selection. The default is public.
4. If you need to connect through an SSH tunnel, enable and configure it (optional):
   • Tunnel host: The hostname of your SSH server.
   • Tunnel port: The port your SSH server is listening on.
   • Authentication type:
     • For password authentication, enter your SSH username and password.
     • For key-based authentication, enter your SSH username, private key, and optional passphrase.
   • Require TLS through tunnel? - Whether to require TLS encryption through the SSH tunnel. Enabled by default. Disable if your database does not support TLS.
5. Click Link

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

Configuration

Selecting columns

By default, PostHog syncs all columns from each table. To sync only specific columns:

1. During source setup, click Columns next to any table in the table picker.
2. Uncheck columns you don't want to sync.
3. Primary key columns and the incremental sync field (if configured) are always synced and cannot be disabled.

You can also change column selection after setup:

1. Go to the sources tab and click your Postgres source.
2. Click Configure next to any schema.
3. Under Columns, select which columns to sync.

Permissions The Postgres source only requires read permissions on the schemas and tables you intend to sync.

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 instance. To ensure this connector works, add these IPs to your inbound security rules:

Note: We currently don't support connections using IPv6, therefore, you may need to enable IPv4 connections to your database. This is required for Supabase, for example.