Re: Locating sharedir in PostgreSQL on Windows

> ------- Original Message -------
> From: Tom Lane <tgl@sss.pgh.pa.us>
> To: "Dave Page" <dpage@postgresql.org>
> Sent: 26/11/07, 22:30:17
> Subject: Re: [HACKERS] Locating sharedir in PostgreSQL on Windows
> 
> "Dave Page" <dpage@postgresql.org> writes:
> > Yes, I know. Peter seemed to be saying that nothing except postgres
> > itself should be in *any* of the installation directories
> 
> Yeah, that's what I think he said too, but it strikes me as a completely
> bogus policy --- what about contrib modules or stuff from pgfoundry
> or any random user-written module that was built with PGXS?  All that
> stuff happily drops files under $libdir and $sharedir, and I see no good
> argument why it shouldn't.

Yup, exactly.

> There is fair room for argument about whether $sharedir is the
> appropriate place for installation-specific config files though.
> Those should probably live in the same place as postgresql.conf
> and friends, ie, typically but not necessarily $PGDATA.  It doesn't
> look like SelectConfigFiles() saves the config directory name anyplace
> where an add-on module could get at it.  We could perhaps fix that for
> 8.3, but it won't help Mark if he insists on a backwards-compatible
> solution.  I suppose he could copy ConfigFileName and strip the last
> component from it?

Wouldn't be difficult, but I suspect Mark is probably using the path for the PostGIS SQL scripts lwgeom.sql,
spatial_ref_sys.sqletc. rather than config files. But, I see he's found his bug now anyway.
 

/D