Re: Runtime SHAREDIR for testing CREATE EXTENSION

On fre, 2012-02-24 at 11:53 -0500, Tom Lane wrote:
> > We have the same problem with testing extensions at build-time in
> the
> > Debian packages. The server's SHAREDIR /usr/share/postgresql/... is
> > only writable by root, while the build is running as buildd user, so
> > there is no way to do "create extension whatimbuildingrightnow" to
> be
> > able to run regression tests, even if this is a cluster I have just
> > created with initdb.
> 
> This seems like nonsense.  If the build process has installed the
> software, you surely have got permissions to write in that directory.

The build process just installs the software in a fake root where it
will be wrapped up by the packaging software.

> If you haven't installed the software, you need to do testing in a
> temporary installation per "make check", and we are able to test
> extensions that way too.
> 
That looks like the right answer.