You can't use PostGIS compiled for one version of PostgreSQL on a different version of PostgreSQL. They are not compatible binaries across versions. We'll have 2.0.1 for PostgreSQL 9.2 available for Windows probably sometime next week. However -- we do have PostGIS 2.1.0SVN available for 9.2 already. You should be able to just copy the files into your 9.2 and run CREATE EXTENSION postgis; as usual. No incompatibilities have been introduced in 2.1.0, just faster and more functionality - http://www.bostongis.com/blog/index.php?/categories/21-waiting_postgis_21 so if you have an app that relies on 2.0 it should work just dandy with 2.1.0 SVN. http://www.postgis.org/download/windows/pg92/buildbot/ and if you restore your 9.1 backup on 9.2 (assuming you used CREATE EXTENSION), it will automatically upgrade itself. You'll want to be on 2.1.0 for 9.2 anyway since that will have features -- SPGist (not yet committed) specifically designed for leveraging 9.2 Hope that helps, Regina and Leo http://www.postgis.us
_____ From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Chris Haste Sent: Wednesday, September 12, 2012 6:50 AM To: postgis-users@postgis.refractions.net Subject: [postgis-users] Postgres 9.2 Hello List, Has anyone successfully installed PostGIS 2.0.1 with Postgres 9.2 on a windows platform? I have tried (using the PostGIS for Postgres 9.1 installer and specifying the 9.2 path during installation) but I keep getting the error when I try and create a DB using CREATE EXTENSION. ERROR: could not load library "C:/Program Files/PostgreSQL/9.2/lib/postgis-2.0.dll": The specified module could not be found. But the DLL is there in that location! Any ideas? Thanks *** This communication has been sent from World Fuel Services Corporation or its subsidiaries or its affiliates for the intended recipient only and may contain proprietary, confidential or privileged information. If you are not the intended recipient, any review, disclosure, copying, use, or distribution of the information included in this communication and any attachments is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to this communication and delete the communication, including any attachments, from your computer. Electronic communications sent to or from World Fuel Services Corporation or its subsidiaries or its affiliates may be monitored for quality assurance and compliance purposes.***
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users