PostgreSQL

As a best practice, create a dedicated PostgreSQL user with only the privileges needed for your Connecty integration and configure SSL mode to meet your security requirements. This isolates your integration credentials and simplifies permission management, ensuring a seamless no-code connection.

Prerequisites

• Host

• Port (default: 5432)

• Username and Password

• Database Name

• (Optional) SSL Mode

1. Host and Port

Your PostgreSQL Host is the address of the server where your database is running.

• This can be an IP address (192.168.1.100) or a hostname (myaurora.cluster-c25.us-east-1.rds.amazonaws.com).

• The Port is usually 5432 unless your administrator has configured a custom port.

• ✅ Host: db.mycompany.com

• ✅ Port: 5432

• ❌ Host: postgres://db.mycompany.com (do not include the protocol in the host field)

2. Username and Password

These credentials authenticate you to the database.

• Username: the database user name.

• Password: the password associated with that user.

3. Database Name

The Database Name is the specific database you want to connect to on the server.

You can list available databases via the \l command in psql or by querying: SELECT datname FROM pg_database WHERE datistemplate = false;

4. SSL Mode (Optional)

Controls whether and how SSL/TLS is used for the connection. Common values:

• disable : no SSL (not recommended).

• require : SSL is required, but the server certificate is not verified.

• verify-ca : SSL required and server certificate must be signed by a trusted CA.

• verify-full : SSL required and server hostname must match certificate.

For verify-ca and verify-full options please contact our support.

If you don’t specify SSL Mode, most clients default to `disable`.