X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id BCF019FA5BF for ; Mon, 24 Jul 2006 12:47:12 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 29871-09 for ; Mon, 24 Jul 2006 12:47:04 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from doubleprime.com (c-67-186-133-72.hsd1.ct.comcast.net [67.186.133.72]) by postgresql.org (Postfix) with SMTP id BA06F9FA5E9 for ; Mon, 24 Jul 2006 12:47:03 -0300 (ADT) Received: (qmail 26850 invoked by uid 500); 24 Jul 2006 15:47:03 -0000 Date: Mon, 24 Jul 2006 11:47:03 -0400 From: Richard Chen To: pgsql-admin@postgresql.org Cc: Richard Chen Subject: How to specify alternative locations for postgresql.{key,crt} files? Message-ID: <20060724154703.GF22464@plex.homeland.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.4.2.1i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.135 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200607/228 X-Sequence-Number: 22474 Hi, The documentation says the locations for these files should be in ~/.postgresql. But we would like to use DBD::Pg and/or psql from within apache which runs as user nobody. We don't have a special home dir for account nobody. Is there a way to specify alternative locations for these files other than ~/.postgresql/? In most unix apps one can specify either via command line option or environment variable the locations for such files. Hard coding this to ~/.postgresql/postgresql.key ~/.postgresql/postgresql.crt seems to be very restrictive to me. Also, what if I have several different ssl enforced postgres servers? Can I lump all the key/crt files in the above files? Can I have separate files for different servers? Thanks Richard