[Dachs-support] dachs error

[Markus Demleitner]

Hi Nathanaël,

On Thu, Sep 06, 2018 at 06:25:49PM +0200, Nathanaël Jourdane wrote:
> In the meanwhile I tried with an other Dockerfile and this one runs dachs but services can 
> not be imported (well, it's better in some way).
> 
> I installed postgresql with pg-sphere and pg-q3 extensions:
> 
> PG_VERSION=9.4
> apt-get install -y postgresql-$PG_VERSION postgresql-$PG_VERSION-pgsphere postgresql-
> $PG_VERSION-q3c
> 
> But on pgAdmin I see that the only installed extension is plpgsql, and the logs/dcErrors. 
> says that "the type "spoly" does not exist", which is, I suppose, related to the pg-sphere 
> extension.
> 
> Does someone know why these pg extensions are badly installed?

Same thing: dachs init magic missing.  You see, it's not enough to
have the postgres extensions binaries, you also need to acquaint each
database you create (DaCHS, of course, only has one, gavo) with what
functions there are.

For new-style extensions like modern pgsphere, this works using
CREATE EXTENSION.  q3c hasn't been updated yet as far as I remember,
so there you have to source a certain script.  Re-building all that
logic certainly isn't worth it, so -- just run dachs init, it will
(in this case hopefully, as it's fragile enough as is) do what's
necessary.

         -- Markus