↑↓ select↵ open⌫ change scopeOpen full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Wiki / Configuration Parameters

ssl_passphrase_command_supports_reload

This parameter determines whether the passphrase command set by ssl_passphrase_command will also be called during a configuration reload if a key file needs a passphrase. If this parameter is off (the default), then ssl_passphrase_command will be ignored during a reload and the SSL configuration will not be reloaded if a passphrase is needed. That setting is appropriate for a command that requires a TTY for prompting, which might not be available when the server is running. Setting this parameter to on might be appropriate if the passphrase is obtained from a file, for example. This parameter must be set to on when running on Windows since all connections will perform a configuration reload due to the different process model of that platform. This parameter can only be set in the postgresql.conf file or on the server command line.

English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.

Reading PG 18·Select a recorded version

boot val
off
category
Connections and Authentication / SSL
context
sighup
documented
true
enumvals
Unknown
extra desc
Unknown
lang
en
max val
Unknown
metadata version
18
min val
Unknown
name
ssl_passphrase_command_supports_reload
short desc
Controls whether "ssl_passphrase_command" is called during server reload.
source
pg-settings-source-snapshot
unit
Unknown
vartype
bool

Definition PG 18

This parameter determines whether the passphrase command set by ssl_passphrase_command will also be called during a configuration reload if a key file needs a passphrase. If this parameter is off (the default), then ssl_passphrase_command will be ignored during a reload and the SSL configuration will not be reloaded if a passphrase is needed. That setting is appropriate for a command that requires a TTY for prompting, which might not be available when the server is running. Setting this parameter to on might be appropriate if the passphrase is obtained from a file, for example. This parameter must be set to on when running on Windows since all connections will perform a configuration reload due to the different process model of that platform. This parameter can only be set in the postgresql.conf file or on the server command line.

Compare versions

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · wiki-repair-20261023:cf7a3aae691b3637b840fd2a368ca77ba734ae95b944ae290abf9f0f0c644483

Text language: en · wiki-repair-20261023:cf7a3aae691b3637b840fd2a368ca77ba734ae95b944ae290abf9f0f0c644483