SSL key with passphrase

From: Thom Brown <thom(at)linux(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: SSL key with passphrase
Date: 2011-09-13 13:54:23
Message-ID: CAA-aLv5b_jN7ek33kWe+pMJgSfbk70CkMVcgvQ9BSiYyZKkQhw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2011-09-13 14:02:51 Re: augmenting MultiXacts to improve foreign keys
Previous Message Peter Eisentraut 2011-09-13 13:51:07 Re: unite recovery.conf and postgresql.conf