pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedssl with pem password
3+ messages / 2 participants
[nested] [flat]
* ssl with pem password
@ 2005-07-25 11:55 Luca Stancapiano <l.stancapiano@k-tech.it>
0 siblings, 1 reply; 3+ messages in thread
From: Luca Stancapiano @ 2005-07-25 11:55 UTC (permalink / raw)
To: pgsql-admin
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?
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: ssl with pem password
@ 2005-07-25 17:15 Tom Lane <tgl@sss.pgh.pa.us>
parent: Luca Stancapiano <l.stancapiano@k-tech.it>
0 siblings, 1 reply; 3+ messages in thread
From: Tom Lane @ 2005-07-25 17:15 UTC (permalink / raw)
To: Luca Stancapiano <l.stancapiano@k-tech.it>; +Cc: pgsql-admin
"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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: ssl with pem password
@ 2005-07-25 18:45 Luca Stancapiano <l.stancapiano@k-tech.it>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 3+ messages in thread
From: Luca Stancapiano @ 2005-07-25 18:45 UTC (permalink / raw)
To: pgsql-admin
> "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'
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2005-07-25 18:45 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-07-25 11:55 ssl with pem password Luca Stancapiano <l.stancapiano@k-tech.it>
2005-07-25 17:15 ` Tom Lane <tgl@sss.pgh.pa.us>
2005-07-25 18:45 ` Luca Stancapiano <l.stancapiano@k-tech.it>
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