PostgreSQL

Read and write any PostgreSQL server: self-hosted, or managed on Amazon RDS and Aurora, Cloud SQL, or Azure Database. Picking a table shows its columns in the builder without running the pipeline.

Category: Database
Used by: 3 nodes

Settings

What the connection form asks for. Every connection has a Staging side, which it needs, and an optional Production side with values of its own; both ask for the same settings.

Host
Port
Database
Username
Password	Stored encrypted, and never shown again after you save it.
Encryption	Managed services (Amazon RDS and Aurora, Cloud SQL, Azure Database) accept verify-full with no extra setup. Use require for a server with a self-signed certificate. Choices: Require encryption; Require encryption, verify certificate and hostname; Require encryption, verify certificate; Encrypt if the server offers it; No encryption.

Testing the connection

Test connects to the server, signs in and runs SELECT 1.

Good to know

Encryption has five settings, from no encryption to verifying the certificate and the hostname. Managed services such as Amazon RDS, Cloud SQL and Azure Database accept the strictest setting with no extra setup.
Picking a table, or writing a query, shows its columns in the builder without running anything: the database plans the query and describes the result.
A blank password means an account with no password, such as one using trust authentication.

Nodes that use it

Database Lookup

Look up each row's keys in a database table and add the matching row's columns.

Postgres input

Read the result of a SQL query from PostgreSQL. A Bookmark can read only the rows added or changed since the last successful run.

Postgres output

Load rows into a PostgreSQL table (append, truncate, or upsert). The load is one transaction by default, so a load that fails leaves the table as it was.