[OSM-Devserver] Fwd: [osmosis-dev] CI-Server (Hudson) for Osmosis?

[Brett Henderson]

Oops, I meant to send to the list.

---------- Forwarded message ----------
From: Brett Henderson <brett at bretth.com>
Date: Sat, Dec 19, 2009 at 2:24 PM
Subject: Re: [osmosis-dev] CI-Server (Hudson) for Osmosis?
To: Jochen Topf <jochen at remote.org>
Cc: hakan at gurkensalat.com


On Thu, Dec 17, 2009 at 8:58 PM, Jochen Topf <jochen at remote.org> wrote:

>
> > 2. A PostGIS enabled schema or an existing template database to create a
> > database from.
>
> Use the "osmtemplate" template database. Despite its name it has nothing to
> do with osm, its just a PostGIS-enabled template.
>

I've created a new database based on this template.

I am trying to create the pgsql simple schema by running the shell script
/osm/osmosis-continuous-integration/database/07_installpgsqldb.sh

Most of it is succeeding, but it is failing when trying to create geometry
columns.  I get an error (using google translate):
ERROR: no permission for relation geometry_columns

The owner of most tables is *osmosisci* as expected.  The owner of the
geometry_columns and spatial_ref_sys tables is *osm*.  The osmosisci user
doesn't appear able to access those two tables.  I get the same error if I
run the query.
select * from geometry_tables;

Any suggestions?

Note that the 07_installpgsqldb.sh shell script can be re-run as many times
as necessary.  It drops all existing tables before creating the tables
again.

Brett
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.openstreetmap.de/pipermail/devserver/attachments/20091219/3950e526/attachment.htm>