Hi, yeah I deinstalled postgis through control panel/programs and the stackbuilder also says, that is not installed. Strange thing is that even the template_postgis is not there anymore the installer warns me that if I install postgis he will overwrite the template_postgis table. So somehow it is still there also I do not see it?
I will try the script on the postgis site that you wrote about, maybe that helps. Ah and no my old database is not working but also when I try to install a new postgresql/postgis (maybe 9.0 or 8.4 with postgis 1.5.3 or 1.4.2) I get the same error with the template_postgis table missing. Best Sebastian 2012/2/26 Paragon Corporation <l...@pcorp.us>: > Sebastian, > > Is your old database working again or not? > > Yah they do get installed by the stack builder. So strange they did not. > It's possible it sensed you already had postgis installed because its in > your registry and did nothing. > > Did you try uninstalling postgis first? You should see it listed in control > panel / programs or you can just uninstall it with > the uninstall file in postgresql folder. > > Then try reinstalling again. Alternatively -- and a safer route if you have > data, just use the batch script in the download zip file from postgis site. > It is set to create a template database as I recall. > > In theory you don't need a template database, and moving forward (9.1+ + > 2.0, we aren't going to bother with a tempalte_postgis, because its much > easier to use CREATE EXTENSION). > > Thanks, > 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 9:08 PM >> To: PostGIS Users Discussion >> Subject: Re: [postgis-users] Unable to laod "C:/Program Files >> (x86)/PostgreSQL/9.1/lib/postgis-1.5.dll" unknown error 998 >> >> 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-t >> emplate-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_pos >> tgis-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 >> > > > _______________________________________________ > 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
