pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Luca Stancapiano <l.stancapiano@k-tech.it>
To: pgsql-admin@postgresql.org
Subject: Re: ssl with pem password
Date: Mon, 25 Jul 2005 20:45:32 +0200 (CEST)
Message-ID: <30724.80.181.228.234.1122317132.squirrel@webmail.k-tech.it> (raw)
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>

> "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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>

sorry but I would really to use the key with password because I use a gpg
system that hide the real password....It's possible with postgres to use a
thing like this?

echo crypted_password | /usr/bin/postmaster -il -p '5432' -D '/home/data'



view thread (3+ messages)

Message-ID: <30724.80.181.228.234.1122317132.squirrel@webmail.k-tech.it>
Permalink:  ../30724.80.181.228.234.1122317132.squirrel@webmail.k-tech.it/
Also on:    postgresql.org/message-id/30724.80.181.228.234.1122317132.squirrel@webmail.k-tech.it

 · 

reply

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: l.stancapiano@k-tech.it
  Subject: Re: ssl with pem password
  In-Reply-To: <30724.80.181.228.234.1122317132.squirrel@webmail.k-tech.it>
  References: <21651.217.221.180.103.1122292551.squirrel@webmail.k-tech.it> <5806.1122311750@sss.pgh.pa.us> <30724.80.181.228.234.1122317132.squirrel@webmail.k-tech.it>

* 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