<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 10.00.9200.16843"></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=331515403-10042014><FONT color=#0000ff
size=2 face=Arial>Jay,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=331515403-10042014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=331515403-10042014><FONT color=#0000ff
size=2 face=Arial>I haven't tested 2.1.2 on a virgin 9.2 install though I
upgraded my existing 9.2 windows 64-bit and create a new db no problem and
upgraded my existing dbs with ALTER EXTENSION postgis...</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=331515403-10042014><FONT color=#0000ff
size=2 face=Arial>Yah I never bother with the "Create spatial database". Was
thinking of removing that in 2.2 though I guess some may find it useful, but
then I'll make user name/password stuff conditional on that.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=331515403-10042014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=331515403-10042014><FONT color=#0000ff
size=2 face=Arial>1) You might want to try right-clicking -- Extension
add-> postgis via pgAdmin to see if you see the option at all and
when you choose it it gives an immediate error if there is an
issue.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=331515403-10042014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=331515403-10042014><FONT color=#0000ff
size=2 face=Arial>Usually when I see this not working -- the culprit often is
one of 2 things</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=331515403-10042014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=331515403-10042014><FONT color=#0000ff
size=2 face=Arial>a) for whatever reason your extension files or postgis.control
is not in the right location -- this usually only happens with copy
fail</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=331515403-10042014></SPAN><SPAN
class=331515403-10042014><FONT color=#0000ff size=2 face=Arial>b) more commonly
</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=331515403-10042014><FONT color=#0000ff
size=2 face=Arial>you connected with postgres account in psql and you didn't
switch to connect to the new database before you ran CREATE EXTENSION, so
postgis ends up being installed in the postgres database</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=331515403-10042014><FONT color=#0000ff
size=2 face=Arial>where its of course no use.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=331515403-10042014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=331515403-10042014><FONT color=#0000ff
size=2 face=Arial>Hope that helps,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=331515403-10042014><FONT color=#0000ff
size=2 face=Arial>Regina</FONT></SPAN></DIV><BR>
<DIV lang=en-us class=OutlookMessageHeader dir=ltr align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B> postgis-users-bounces@lists.osgeo.org
[mailto:postgis-users-bounces@lists.osgeo.org] <B>On Behalf Of </B>Jay
Moss<BR><B>Sent:</B> Wednesday, April 09, 2014 12:59 PM<BR><B>To:</B>
postgis-users@lists.osgeo.org<BR><B>Subject:</B> [postgis-users] problems with
2.1.2 and new databases<BR></FONT><BR></DIV>
<DIV></DIV>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></BODY></HTML>