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

[Paragon Corporation]

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
>