pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedHow to specify alternative locations for postgresql.{key,crt} files?
2+ messages / 2 participants
[nested] [flat]
* How to specify alternative locations for postgresql.{key,crt} files?
@ 2006-07-24 15:47 Richard Chen <richard@doubleprime.com>
0 siblings, 1 reply; 2+ messages in thread
From: Richard Chen @ 2006-07-24 15:47 UTC (permalink / raw)
To: pgsql-admin; +Cc: Richard Chen <richard@doubleprime.com>
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: How to specify alternative locations for
@ 2006-08-10 02:53 Bruce Momjian <bruce@momjian.us>
parent: Richard Chen <richard@doubleprime.com>
0 siblings, 0 replies; 2+ messages in thread
From: Bruce Momjian @ 2006-08-10 02:53 UTC (permalink / raw)
To: Richard Chen <richard@doubleprime.com>; +Cc: 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. +
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2006-08-10 02:53 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-07-24 15:47 How to specify alternative locations for postgresql.{key,crt} files? Richard Chen <richard@doubleprime.com>
2006-08-10 02:53 ` Re: How to specify alternative locations for Bruce Momjian <bruce@momjian.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox