Re: Locating sharedir in PostgreSQL on Windows

> ------- Original Message -------
> From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
> To: "Dave Page" <dpage(at)postgresql(dot)org>
> Sent: 26/11/07, 22:30:17
> Subject: Re: [HACKERS] Locating sharedir in PostgreSQL on Windows
>
> "Dave Page" <dpage(at)postgresql(dot)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.sql etc. rather than config files. But, I see he's found his bug now anyway.

/D