Enables SNI configuration for SSL connections.
At a glance
| Property | Value |
|---|---|
| Parameter | ssl_sni |
| Category | Connections and Authentication |
| Default | off |
| Value type | boolean (on/off) |
| Change scope | Reload (postgresql.conf, SIGHUP) |
| Available in | PostgreSQL 19 (added in 19) |
What it does
Enables SNI configuration for SSL connections. When set to on host configuration from hosts_file is used, see ssl_sni for more details.
This parameter can only be set in the postgresql.conf file or on the server command line. The default is off.
(Description quoted from the official PostgreSQL documentation.)
How to apply a change
Set it in postgresql.conf (or with ALTER SYSTEM) and reload with SELECT pg_reload_conf(); or pg_ctl reload — no restart needed.
Inspect the current value and source with SHOW ssl_sni; or SELECT name, setting, unit, context, source FROM pg_settings WHERE name = 'ssl_sni';.
Tuning guidance
This is a connectivity or security setting, not a performance knob. Choose the value from your security and network requirements (TLS files, ciphers, keepalives, authentication behaviour) rather than for throughput, and verify it against your organization’s policy. Test changes in staging, because a wrong value here can lock clients out.