Обсуждение: How to specify alternative locations for postgresql.{key,crt} files?

Поиск
Список
Период
Сортировка

How to specify alternative locations for postgresql.{key,crt} files?

От
Richard Chen
Дата:
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


Re: How to specify alternative locations for

От
Bruce Momjian
Дата:
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. +