SSL key with passphrase
Thom Brown <thom@linux.com>
From: Thom Brown <thom@linux.com>
To: PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2011-09-13T13:54:23Z
Lists: pgsql-hackers
Hi, There appears to be a problem with starting Postgres if the SSL key has a passphrase on it. The following happens: Enter PEM pass phrase: FATAL: could not load private key file "server.key": problems getting password Starting with "postgres -D /path/to/cluster" returns: Enter PEM pass phrase: LOG: database system was shut down at 2011-09-13 13:51:51 BST LOG: database system is ready to accept connections LOG: autovacuum launcher started So the postgres binary accepts stdin, but pg_ctl doesn't. This isn't an unusual case, so could I request a fix to allow pg_ctl to take stdin rather than /dev/null? Thanks -- Thom Brown Twitter: @darkixion IRC (freenode): dark_ixion Registered Linux user: #516935 EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company