Mmmhhh maybe another thing: I also checked the registry and under HKEY_CURRENT_USER\Software\pgAdmin III\Servers I find three identical server 1, 2 and 3 with the exact same databases. Is that correct? But maybe that has nothing to do with the error message I get ...
2012/2/26 Paragon Corporation <l...@pcorp.us>: > You might have multiple versions of PostgreSQL running on your server. > Maybe one of them already has postgis 1.5 and you didn't change the port to > the new one you have. It usually picks up the port from the registry via > stackbuilder, but sometimes it doesn't and you have to manually change > during installation. > > Check the folders: > > C:\Program Files (x86)\PostgreSQL (32-bit ones get installed here) > C:\Program Files\PostgreSQL (64 bit versions get installed here) > > We have 4 running on my windows server so I have subfolders in the x86 (8.4, > 9.0, 9.1) > and a 9.0, 9.1 in my 64-bit folder. > > All running on different ports. > > > > >> -----Original Message----- >> From: postgis-users-boun...@postgis.refractions.net >> [mailto:postgis-users-boun...@postgis.refractions.net] On >> Behalf Of Sebastian Matyas >> Sent: Sunday, February 26, 2012 1:58 AM >> 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 >> >> 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 >> > > > _______________________________________________ > 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
