Here is a patch that adds a way to specify an external command for
obtaining SSL passphrases. There is a new GUC setting
ssl_passphrase_command.
Right now, we rely on the OpenSSL built-in prompting mechanism, which
doesn't work in some situations, including under systemd. This patch
allows a configuration to make that work, e.g., with systemd-ask-password.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services