Purpose

PostgreSQL 12 or later, including compatible services (Amazon RDS, Azure Database for PostgreSQL).

Connection fields

Interface screenshotEnlarge ↗PostgreSQL connection fields. A training form with server db.example, port 5432 and database analytics_demo. No external database connection was made.
PostgreSQL connection fields

A training form with server db.example, port 5432 and database analytics_demo. No external database connection was made.

FieldRule and default valueExplanation
Server (name or IP address)
host		RequiredSet the value according to your service configuration.
Port
port		As configured
Default: 5432
Range: 1–65535		Set the value according to your service configuration.
Database
database		RequiredSet the value according to your service configuration.
User
username		RequiredSet the value according to your service configuration.
Encryption
sslmode		As configured
Default: prefer		prefer — Prefer when available
require — Required
verify-full — Required, with certificate validation
disable — Disabled
Password
secret		Separate protected fieldThe secret is not displayed after saving. An empty field in an existing connection preserves its current secret.

Setup and validation

  1. Create a connection and give it a clear name.
  2. Complete required fields and the separate secret field.
  3. Run “Test” and read the diagnostics.
  4. Save the connection and select it in the appropriate flow block.

A successful test does not replace checking access to the required object and specific write mode.

Use in a flow

Server and account settings are stored in the connection. The specific object, fields and flow behavior are defined in the block. Go to data-handling rules →