pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
How 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