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.
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.
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.
Last updated