Re: How to specify alternative locations for - Mailing list pgsql-admin

From Bruce Momjian
Subject Re: How to specify alternative locations for
Date
Msg-id 200608100253.k7A2rwh03707@momjian.us
Whole thread Raw
In response to How to specify alternative locations for postgresql.{key,crt} files?  (Richard Chen <richard@doubleprime.com>)
List pgsql-admin
I suggest you use symlinks to accomplish this.  I don't think we have
enough demand to make this configurable.

---------------------------------------------------------------------------

Richard Chen wrote:
> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend

--
  Bruce Momjian   bruce@momjian.us
  EnterpriseDB    http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

pgsql-admin by date:

Previous
From: adey
Date:
Subject: Re: How to know the sizes of all tables & indexes in a database
Next
From: adey
Date:
Subject: Re: vacuumdb exclude tables option?