How to specify alternative locations for postgresql.{key,crt} files? - Mailing list pgsql-admin

From Richard Chen
Subject How to specify alternative locations for postgresql.{key,crt} files?
Date
Msg-id 20060724154703.GF22464@plex.homeland.com
Whole thread Raw
Responses Re: How to specify alternative locations for
List pgsql-admin
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


pgsql-admin by date:

Previous
From: Omer Mustafa
Date:
Subject: Connection refused. Check that the hostname and port are correct
Next
From: "Erik Ferencz"
Date:
Subject: ODBC connection problem