[Pkg-postgresql-public] [pgsql-pkg-debian] Debian packaging of the q3c and pgsphere extensions

[Ole Streicher]

Hi Christoph,

thank you very much for your reply with a first help.


On 03.08.2017 11:25, Christoph Berg wrote:
> Florian was talking to me about these some years back, iirc we were
> close to getting the packages polished up, but then communication got
> stuck at some point. Thanks for taking this up again!

I have polished both packages, with the repository still in the
debian-science section (but I will move them to pkg-postgresql as soon
as I become a member). They look fine to me now (except tests; see
below), but could you have a look there?

> I'd also like to include the packages on apt.postgresql.org.

Sure, however this is out of my own scope.

> pg_buildext(1) and dh_make_pgxs(1) (both from postgresql-server-dev-all)
> should provide a working skeleton at least for the case of extension-only
> packages.

Yea, pg_buildext is nice.

> Fwiw, I'd strongly recommend to add a debian/tests/ testsuite (see
> also pg_buildext(1)), even if it's just a "create extension q3c;", so
> we have some test coverage.

I'd love to. Especially q3c has this already enabled. However I don't
know how to enable a test postgresql database server. When I just add
postgresql-client to d/control[.in], I get

createdb q3c_test
createdb: could not connect to database template1: could not connect to
server: No such file or directory
	Is the server running locally and accepting
	connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
Makefile:37: recipe for target 'test' failed

during the build. Do you have any hints here?

Best regards

Ole