X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 8483052ACD for ; Mon, 25 Jul 2005 15:50:40 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 54235-05 for ; Mon, 25 Jul 2005 18:50:37 +0000 (GMT) Received: from ulisses.local.k-tech.it (unknown [62.101.92.221]) by svr1.postgresql.org (Postfix) with SMTP id 5BC1252AA3 for ; Mon, 25 Jul 2005 15:50:34 -0300 (ADT) Received: (qmail 16598 invoked by uid 72); 25 Jul 2005 18:45:32 -0000 Received: from 80.181.228.234 (SquirrelMail authenticated user k-tech-it-l.stancapiano) by webmail.k-tech.it with HTTP; Mon, 25 Jul 2005 20:45:32 +0200 (CEST) Message-ID: <30724.80.181.228.234.1122317132.squirrel@webmail.k-tech.it> 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> Date: Mon, 25 Jul 2005 20:45:32 +0200 (CEST) Subject: Re: ssl with pem password From: "Luca Stancapiano" To: pgsql-admin@postgresql.org User-Agent: SquirrelMail/1.4.2 MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 Importance: Normal X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.038 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200507/196 X-Sequence-Number: 18252 > "Luca Stancapiano" 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'