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: [email protected] [mailto:[email protected]] On Behalf Of jamo3 Sent: Thursday, April 10, 2014 10:23 AM To: [email protected] 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 [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
