SSL Configuration Settings
To enable SSL support, the following settings must be correctly configured:- mode:
require
oroptional
- cert_file: path to the server’s public certificate in PEM format
- key_file: path to the server’s private key in PEM format
ca_crt_file
, which is used to verify whether the certificate was signed by the Certificate Authority (CA) is optional.
The settings for
min_protocol_version
and max_protocol_version
can be omitted, as they have default values.SSL Enabled Configuration (Mode: Optional)
Clients are authorized to establish connections using both non-SSL and SSL protocols. Connections established withsslmode=require
or sslmode=disable
will be accepted.
SSL Enabled Configuration (Mode: Require)
Clients are permitted to connect only through SSL connections. Any attempts to establish a connection using tools that require SSL, such aspsql
with the sslmode=disable
option, will be rejected.
SSL Disabled Configuration
Clients are permitted to connect only through non-SSL connections. Any attempts to establish a connection using tools that require SSL, such aspsql
with the sslmode=require
option, will be rejected.
SSL Modes Description Table
SSL Mode | Eavesdropping Protection | Support |
---|---|---|
off | No | SSL connections not supported |
require | Yes | Only SSL connections are allowed |
optional | Yes | both SSL and no SSL connections are supported |