Dear Leo and Regina, thanks for your fast answer. Indeed I try to reinstall the postgis-1.5 version (32bit) through the stackbuilder of postgresql 9.1 but now it always gives me an error that the "template_postgis" database does not exist. I checked with pgadmin and it is indeed not there but I thought it would be created in the process of installation?
I mean the template was there before but I deleted it by hand (using the steps described here http://blog.kimiensoftware.com/2011/03/postgresql-dropping-a-template-database-47 and then I tried to build it from hand using the steps described here http://brandonkonkle.com/blog/2010/jul/19/setting-template_postgis-lucid/ but when I run the sql scripts I get alot of erro messages). The reason was that the geometry and spatial_ref_sys table were not there anymore. So I guessed it will not work anyway as a template. Btw the files that the postgis-1.5.dll depends are not there - I checked with the depencywalker - but I thought they get installed when I use the stackbuilder or not? Thanks for your answer in advance. Best Sebastian 2012/2/26 Paragon Corporation <l...@pcorp.us>: > Sebastian, > > I presume you installed the 32-bit PostgreSQL the second time around you > installed right? > If not that is probably your problem since PostGIS is not yet supported on > the 64-bit EDB windows builds > (just the 32-bit installers). If you are interested in supporting our > efforts to build a 64-bit windows version then you can contribute to our > campaign > > http://www.pledgebank.com/postgis64windows > > > Other reasons why you get this error: > 1) one of the files postgis-1.5.dll depends on is not there. > common culprits which should be in the bin folder of your PostgreSQL \ bin > folder are > > libgeos_c-1.dll, libgeos-3-3-2.dll, libproj.dll,libiconv-2.dll, > libxml-2-2.dll > > If all those are present in your PostgreSQL bin, then use dependency walker > to check the dependencies which you can download from here > > http://www.dependencywalker.com/ > > 2) You are using the wrong postgis-1.5.dll -- note that there is a different > version for each version of PostgreSQL. So if you say try to use a 9.0 > postgis 1.5 with 9.1 version of PostgreSQL, it won't work. > > You can download the one for your install from here and replace the > postgis-1.5.dll if that is the case: > > http://www.postgis.org/download/windows/ > > Hope that helps, > Leo and Regina > http://www.postgis.us > > > > >> -----Original Message----- >> From: postgis-users-boun...@postgis.refractions.net >> [mailto:postgis-users-boun...@postgis.refractions.net] On >> Behalf Of Sebastian Matyas >> Sent: Saturday, February 25, 2012 11:20 AM >> To: postgis-users@postgis.refractions.net >> Subject: [postgis-users] Unable to laod "C:/Program Files >> (x86)/PostgreSQL/9.1/lib/postgis-1.5.dll" unknown error 998 >> >> Dear all, >> >> I recently ran into a weird error for which I cannot find a >> solution (tried Google and such) adn I could really use your help. >> I installed posgresql 9.1 and postgis 1.5.3 on a Windiws Server 2008 >> R2 (64bit) machine and for some time everything went fine. >> Then two days ago I was not able to view any data table that >> used the geography data type anymore though I didn´t change >> anything on the server or the postgis configuration. >> >> When I then tried to analyze or dump the database I getan >> error which says that psql was not able to laod the >> postgis-1.5.dll (unknown error >> 998) which is strange as the dll is located in the directory >> which is given in the error message. I also deinstalled >> postgis and tried to install it again but then I get the same >> error message. >> >> Please help me cause I cannot find a solution and I really >> need the data... >> >> Best regards >> Sebastian Matyas >> _______________________________________________ >> postgis-users mailing list >> postgis-users@postgis.refractions.net >> http://postgis.refractions.net/mailman/listinfo/postgis-users >> > > > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
