Dear Regina, thank you very much for your help. Now it works again - I also could install postgis with the stackbuilder again with no problems (before that I was already able to view and dump my database also again with no problems).
It seems restarting the service was the key - too bad I didn´t thought about that earlier but as the database itself was running fine (and only the tables with the geography datatype were not working), I didn´t thought that would be the problem. The only other thing I did was to put the bin-/lib-folder in the PATH variable but I guess that doesn´t make a difference. Btw I did restart it through the windows menu as restarting the service with the console led to a 1063 error. Anyway it works now - though I am still not sure what caused the problem in the first place. Best Sebastian 2012/2/27 Paragon Corporation <l...@pcorp.us>: > Sebastian, > That shouldn't matter. That just affects what you see in pgAdmin. > As far as dependency walker goes those errors are fine since the lib becomes > part of path when postgresql launches so it can find it then. > > Only other thoughts > > 1) is to look in the pg_log folder in your data folder at the error. That > sometimes gives more clues. > 2) In your services, verify the executable and data path are what you think > they aree. > > For example our 9.1 services path to executable looks like this when we go > to control -> Services > > C:/Program Files (x86)/PostgreSQL/9.1/bin/pg_ctl.exe runservice -N > "postgresql-9.1" -D "E:/PGData91X32" -w > > > 3) Shut off the service and try to start postgres from the console instead > of the service > use pg_ctl -D path to your data folder. > e.g. > > "C:/Program Files (x86)/PostgreSQL/9.1/bin/pg_ctl.exe" -D "E:/PGData91X32" > -w > > You also want to check your postgresql.conf file that is located in your > datafolder to make sure it is listening on the port you think it is. > > Aside from that its really hard to diagnose without seeing your computer. > > 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: Sunday, February 26, 2012 8:24 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 >> >> 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 >> > > > _______________________________________________ > 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
