Re: How to specify alternative locations for

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Richard Chen <richard(at)doubleprime(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: How to specify alternative locations for
Date: 2006-08-10 02:53:58
Message-ID: 200608100253.k7A2rwh03707@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)momjian(dot)us
EnterpriseDB http://www.enterprisedb.com

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message adey 2006-08-10 04:01:47 Re: vacuumdb exclude tables option?
Previous Message adey 2006-08-10 00:39:58 Re: How to know the sizes of all tables & indexes in a database