I've got a problem with the new 2.1.2 release. If I upgrade in place everything appears fine. <div><br></div><div>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:<div>
<br></div><div> PostGIS is already installed in schema 'public', uninstall it first</div><div><br></div><div>Here's my installation process and what's failing:</div><div><br></div><div> 1. create a new db using createdb.exe.</div>
<div> 2. spatially enable it using psql and "CREATE EXTENSION postgis".</div><div> 3. create some permissions, groups, and roles, and grant access to the db...</div><div> 4. update the postgressql search path to add my new db at the front of the list.</div>
<div> 5. run \share\contrib\postgis-2.1\postgis.sql - FAILS</div><div> 6. run \share\contrib\postgis-2.1\spatial_ref_sys.sql</div><div> 7. run \share\contrib\postgis-2.1\postgis_comments.sql</div><div><br></div>
<div>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.</div>
</div><div><br></div><div>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.</div>
<div><br></div><div>thanks in advance</div><div>j</div>