Postgres

This page contains the setup guide and reference information for Postgres.

Postgres is an open-source relational database commonly used as an application database and analytical destination. Use this destination to load Daspire source data into a Postgres database.

Prerequisites

• A reachable Postgres database
• A database user with permission to create schemas, create tables, insert rows, and update rows
• Network access from Daspire to the Postgres host

Setup guide

Step 1: Prepare a Postgres user and schema

1. Create a dedicated Postgres user for Daspire.
2. Create a target database and schema, or choose an existing schema.
3. Grant the Daspire user the required permissions on the target schema.
4. Confirm that SSL settings match your database requirements.

Step 2: Set up Postgres in Daspire

1. Select Postgres from the Destination list.
2. Enter a Destination Name.
3. Enter the host, port, database, schema, username, and password.
4. Select the SSL mode required by your database.
5. Click Save & Test.

Supported sync modes

Feature	Supported?
Append	Yes
Append + Deduped	Yes - recommended
Overwrite	Yes
Normalized tables	Yes

Troubleshooting

If the connection test fails, confirm the host, port, credentials, SSL mode, network allowlist, and schema permissions. If writes fail after a successful connection test, verify that the Daspire user can create and update tables in the target schema.