[postgis-users] problems with 2.1.2 and new databases

[Jay Moss]

I've got a problem with the new 2.1.2 release.  If I upgrade in place
everything appears fine.

BUT, if I'm installing a new db server (PostgreSQL 9.2.8.2, 64bit,
windows), the create script that I have been using successfully with
previous versions now fails (in step 5 below) with the following error:

    PostGIS is already installed in schema 'public', uninstall it first

Here's my installation process and what's failing:

   1. create a new db using createdb.exe.
   2. spatially enable it using psql and "CREATE EXTENSION postgis".
   3. create some permissions, groups, and roles, and grant access to the
db...
   4. update the postgressql search path to add my new db at the front of
the list.
   5. run  \share\contrib\postgis-2.1\postgis.sql  -  FAILS
   6. run  \share\contrib\postgis-2.1\spatial_ref_sys.sql
   7. run  \share\contrib\postgis-2.1\postgis_comments.sql

I've tried removing the postgis scripts (all 3) and if I do that, my
database does not appear to actually work with the spatial datatypes - I
get errors that my geometry columns datatype isn't defined.  The second and
third script appear to be dependent on the first.

One other item of note: When I install PostGIS, I'm NOT checking the
"create spatial database" option. I don't really want the sample db's on my
servers - I just want the one I create to be spatially enabled.

thanks in advance
j
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20140409/41849a0f/attachment.html>