🧮
Data Sources
📈
Segments
🛫
Destinations (app)
Postgres
This page walks through how to connect Census with your PostgreSQL database.
🏃♀️ Getting Started
This guide shows you how to use Census to connect your PostgreSQL database to your data warehouse and create your first sync.
Prerequisites
- Have your database credentials ready.
- Have the proper credentials to access your data source. See our docs for each supported data source for further information:
Step 1: Connect Postgres
- Click the Add Service button
- Select Postgres in the list
You'll be prompted to put the following credentials into the Census page.
As listed, we need the Hostname, Port, Database, Username, and Password
After clicking connect, Census will test the connection that was specified.
A Green , means you are good to go
✅
After the connection is verified, you all tables will be exposed, but please take a look below on some of the specifics.
⬇
🗄️ Supported Objects
We support syncing data to Tables in Postgres, but they must have a uniqueness constraint on a column.
Object Name
Supported
Identifiers
Table
✅
Primary Keys or Columns with Uniqueness Constraints
🔄 Supported Sync Behaviors
Behaviors
Supported?
Objects?
Update
✅
All
Update or Create
✅
All
❗️Common troubleshooting issues
You may be trying to sync to a table that does not have a uniqueness constraint. If possible, you need to add one to be able to sync to it. The syntax to do so is here.
🚑 Need help connecting to Postgres?
Last modified 1mo ago