Connect to PostgreSQL
Configure PostgreSQL host, SSL/TLS, SSH tunnels, certificates and session options before testing the connection.
The PostgreSQL form is titled PostgreSQL connection. It keeps the basic connection fields visible and puts certificates, SSH and session behavior in sections you can open when needed.
Basic connection fields
- Enter a connection name.
- Fill in host, port, user, password and database.
- Use test connection before saving.
- Choose an environment, color and optional folder so production connections stay easy to recognize.
The form can also import from URL. It accepts a PostgreSQL URL, decodes the credentials, and lets you choose the resulting SSL mode in the form. If the URL contains an unknown mode, Tablyne reports it instead of silently treating it as a stronger setting.
SSL/TLS
Open SSL/TLS to choose one of the actual PostgreSQL modes:
- disable — no encryption
- allow — tries without SSL, falls back to SSL if the server requires it
- prefer — tries SSL, falls back to no SSL if unsupported
- require — requires SSL, no certificate verification
- verify-ca — requires SSL + verifies the chain against the CA
- verify-full — requires SSL + verifies chain and hostname
A new connection to a host outside this computer starts in verify-full; on this computer (loopback or a Unix socket) it starts in prefer. Saved connections keep their mode.
The same section accepts CA certificate (root cert), client certificate, client private key and SSL key password. Paste PEM content or use browse file. With an empty CA certificate, verify-full trusts the system roots (the operating system’s certificate store; the public Mozilla roots only when that store is empty or unreadable; plus the CA from Settings › Network), also for pg_dump, pg_restore and psql; a pasted CA replaces all of them. verify-ca requires a pasted CA (it checks only the chain, so against public roots it would accept any public certificate). Through an SSH or SSM tunnel the certificate is checked against the host you typed, not the tunnel address.
SCRAM authentication with fewer than 4096 iterations (the PostgreSQL default) or more than 100,000 is refused before the password proof is computed.
SSH and advanced options
Turn on Over SSH for a tunnel. The form supports SSH host, SSH port, SSH user, authentication, SSH password, private key path, key passphrase and an optional jump host / bastion. Blank fields fall back to ~/.ssh/config.
The Advanced section exposes connect timeout (seconds), application name, target session attrs, channel binding, session options, TCP keepalive and keepalive idle (seconds).
Use Ctrl+S to save pending changes. If the form is dirty, closing it asks before discarding the connection changes.