Links

PostgreSQL

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

Step 1: Connect PostgreSQL

  • Once you're in Census, navigate to Connections
  • Click the Add Service button
  • Select PostgreSQL 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 all of your tables will be exposed, but please take a look below for more specifics.

🗄️ Supported Objects

We support syncing data to Tables in PostgreSQL, 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

Learn more about all of our sync behaviors on our Core Concepts page.
Behaviors
Supported?
Objects
Update
All
Update or Create
All
Contact us if you want Census to support more Sync behaviors for PostgreSQL.

❗️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 PostgreSQL?

Contact us via [email protected] or start a conversation with us via the in-app chat.