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 D4FB152AD4 for ; Mon, 25 Jul 2005 14:15:54 -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 32587-03 for ; Mon, 25 Jul 2005 17:15:52 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 0406D52808 for ; Mon, 25 Jul 2005 14:15:51 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j6PHFoFR005807; Mon, 25 Jul 2005 13:15:50 -0400 (EDT) To: "Luca Stancapiano" Cc: pgsql-admin@postgresql.org Subject: Re: ssl with pem password 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> Comments: In-reply-to "Luca Stancapiano" message dated "Mon, 25 Jul 2005 13:55:51 +0200" Date: Mon, 25 Jul 2005 13:15:50 -0400 Message-ID: <5806.1122311750@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200507/194 X-Sequence-Number: 18250 "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