Search PostgreSQL documentation
PG 18 · Browse by category, or enter a name or keyword
Category index55
sslcertmodeThis option determines whether a client certificate may be sent to the server, and whether the server is required to request one. There are three modes:
TLS
sslcertmode
Client library libpq…
sslcompressionIf set to 1, data sent over SSL connections will be compressed. If set to 0, compression will be disabled. The default is 0. This parameter is ignored if a connection without SSL is made.
T…
sslcrlThis parameter specifies the file name of the SSL server certificate revocation list (CRL). Certificates listed in this file, if it exists, will be rejected while attempting to authenticate …
sslcrldirThis parameter specifies the directory name of the SSL server certificate revocation list (CRL). Certificates listed in the files in this directory, if it exists, will be rejected while atte…
sslkeyThis parameter specifies the location for the secret key used for the client certificate. It can either specify a file name that will be used instead of the default ~/.postgresql/postgresql.…
sslkeylogfileThis parameter specifies the location where libpq will log keys used in this SSL context. This is useful for debugging PostgreSQL protocol interactions or client connections using network in…
sslmodeThis option determines whether or with what priority a secure SSL TCP/IP connection will be negotiated with the server. There are six modes:
TLS
sslmode
Client library libpq 10.23
Manual de…
sslnegotiationThis option controls how SSL encryption is negotiated with the server, if SSL is used. In the default postgres mode, the client first asks the server if SSL is supported. In direct mode, the…
sslpasswordThis parameter specifies the password for the secret key specified in sslkey , allowing client certificate private keys to be stored in encrypted form on disk even when interactive passphras…
sslrootcertThis parameter specifies the name of a file containing SSL certificate authority ( CA ) certificate(s). If the file exists, the server's certificate will be verified to be signed by one of t…
sslsniIf set to 1 (default), libpq sets the TLS extension “ Server Name Indication ” ( SNI ) on SSL-enabled connections. By setting this parameter to 0, this is turned off.
TLS
sslsni
Client libr…
target_session_attrsThis option determines whether the session must have certain properties to be acceptable. It's typically used in combination with multiple host names to select the first acceptable alternati…
tcp_user_timeoutControls the number of milliseconds that transmitted data may remain unacknowledged before a connection is forcibly closed. A value of zero uses the system default. This parameter is ignored…
ttyIgnored (formerly, this specified where to send server debug output).
Session and protocol
tty
Client library libpq 10.23
Manual definition Documented
Source environment fallback PGTTY
Comp…
userPostgreSQL user name to connect as. Defaults to be the same as the operating system name of the user running the application.
Authentication
user
Client library libpq 10.23
Manual definitio…
More results
Find definitions in the PostgreSQL manuals, reference library, and extension catalogue.
Searching every version by default. Manual pages are indexed for PostgreSQL 10–20; the reference library and extension catalogue are not version-bound.
all: every version pg17: one version ex: extensions only ↑↓ select ↵ open