[postgis-users] Unable to laod "C:/Program Files (x86)/PostgreSQL/9.1/lib/postgis-1.5.dll" unknown error 998

Sun Feb 26 00:15:21 PST 2012

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-bounces at postgis.refractions.net 
> [mailto:postgis-users-bounces at 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 <lr at 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-bounces at postgis.refractions.net
> >> [mailto:postgis-users-bounces at 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 <lr at 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-bounces at postgis.refractions.net
> >> >> [mailto:postgis-users-bounces at postgis.refractions.net] On
> >> Behalf Of
> >> >> Sebastian Matyas
> >> >> Sent: Saturday, February 25, 2012 11:20 AM
> >> >> To: postgis-users at 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 at postgis.refractions.net
> >> >> http://postgis.refractions.net/mailman/listinfo/postgis-users
> >> >>
> >> >
> >> >
> >> > _______________________________________________
> >> > postgis-users mailing list
> >> > postgis-users at postgis.refractions.net
> >> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >> _______________________________________________
> >> postgis-users mailing list
> >> postgis-users at postgis.refractions.net
> >> http://postgis.refractions.net/mailman/listinfo/postgis-users
> >>
> >
> >
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 