From: Tom Lane <tgl@sss.pgh.pa.us>
To: Luca Stancapiano <l.stancapiano@k-tech.it>
Cc: pgsql-admin@postgresql.org
Subject: Re: ssl with pem password
Date: Mon, 25 Jul 2005 13:15:50 -0400
Message-ID: <5806.1122311750@sss.pgh.pa.us> (raw)
In-Reply-To: <21651.217.221.180.103.1122292551.squirrel@webmail.k-tech.it>
References: <21651.217.221.180.103.1122292551.squirrel@webmail.k-tech.it>
"Luca Stancapiano" <l.stancapiano@k-tech.it> writes:
> hi.....I'm trying to use postgresql in mode ssl and I would to use a
> private key that uses a pem password. When I launch postgres with
> postgres user and my server.key and server.crt in my home ,in this mode:
> echo password | /usr/bin/postmaster -il -p '5432' -D '/home/data'
> I see this message:
> Enter PEM pass phrase
> but I would a thing more automatic without that password request. Is it
> possible?
If you want the server to launch without a password, you have to alter
the server key file to remove its password. See the documentation.
The above is hardly a more-secure approach, since anyone who can look at
the script (or happen to see the "echo" executing in ps) can find out
the password. You might as well rely on file permissions to prevent
people from getting at the password-less key file.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, l.stancapiano@k-tech.it
Subject: Re: ssl with pem password
In-Reply-To: <5806.1122311750@sss.pgh.pa.us>
References: <21651.217.221.180.103.1122292551.squirrel@webmail.k-tech.it> <5806.1122311750@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox