[postgis-users] problems with 2.1.2 and new databases

[Paragon Corporation]

Jamo3,

I wasn't suggesting pgAdmin as a solution, more just an easy check to see
what is wrong with the create extension feature in your system.

Doesn't make much sense that the scripts would work when CREATE EXTENSION
doesn't since they run pretty much the same thing. My concern is your
scripts may be out of date.

Did you see any error at all when running CREATE EXTENSION?v Did you run the
SELECT postgis_full_version(); command to verify you are now running 2.1.2?

Thanks,
Regina

 

-----Original Message-----
From: postgis-users-bounces at lists.osgeo.org
[mailto:postgis-users-bounces at lists.osgeo.org] On Behalf Of jamo3
Sent: Thursday, April 10, 2014 10:23 AM
To: postgis-users at lists.osgeo.org
Subject: Re: [postgis-users] problems with 2.1.2 and new databases

I upgraded just fine, it was only in creating a new db that I ran into
problems.  I removed the "create extension" command and everything worked
just fine with both 2.1.1 and 2.1.2.

I double checked the old "create extension" command in our script and it did
specify the db name correctly here's the command (this is via a windows
batch file, DB_NAME is the db being created): 

.\bin\psql.exe -d %DB_NAME% -U %POSTGRESQL_SUPER_USER% -c "CREATE EXTENSION
postgis"  

We want to automate as much of our installs as possible, so the option of
enabling a db in PgAdmin is a non-starter for us.  We completely automate
the db creation, schema creation, reference table population, and db
version/releases all through scripts (we version via Liquibase - highly
recommended),

Personally I'm OK with running the /contrib scripts as needed.  It would be
nice if the doc page explained that a little better - what each one does,
whether it's required, and what you would need it for.

thanks,
Jay



--
View this message in context:
http://postgis.17.x6.nabble.com/problems-with-2-1-2-and-new-databases-tp5006
071p5006082.html
Sent from the PostGIS - User mailing list archive at Nabble.com.
_______________________________________________
postgis-users mailing list
postgis-users at lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users