Oops, I meant to send to the list.<br><br><div class="gmail_quote">---------- Forwarded message ----------<br>From: <b class="gmail_sendername">Brett Henderson</b> <span dir="ltr"><<a href="mailto:brett@bretth.com">brett@bretth.com</a>></span><br>
Date: Sat, Dec 19, 2009 at 2:24 PM<br>Subject: Re: [osmosis-dev] CI-Server (Hudson) for Osmosis?<br>To: Jochen Topf <<a href="mailto:jochen@remote.org">jochen@remote.org</a>><br>Cc: <a href="mailto:hakan@gurkensalat.com">hakan@gurkensalat.com</a><br>
<br><br><div class="gmail_quote"><div class="im">On Thu, Dec 17, 2009 at 8:58 PM, Jochen Topf <span dir="ltr"><<a href="mailto:jochen@remote.org" target="_blank">jochen@remote.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br><div>
> 2. A PostGIS enabled schema or an existing template database to create a<br>
> database from.<br>
<br>
</div>Use the "osmtemplate" template database. Despite its name it has nothing to<br>
do with osm, its just a PostGIS-enabled template.<br></blockquote></div><div><br>I've created a new database based on this template.<br><br>I am trying to create the pgsql simple schema by running the shell script<br>
/osm/osmosis-continuous-integration/database/07_installpgsqldb.sh<br>
<br>Most of it is succeeding, but it is failing when trying to create geometry columns. I get an error (using google translate):<br>ERROR: no permission for relation geometry_columns<br><br>The owner of most tables is <b>osmosisci</b> as expected. The owner of the geometry_columns and spatial_ref_sys tables is <b>osm</b>. The osmosisci user doesn't appear able to access those two tables. I get the same error if I run the query.<br>
select * from geometry_tables;<br><br>Any suggestions?<br><br>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.<br><br>
Brett<br></div></div><br>
</div><br>