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

[Sebastian Matyas]

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-template-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_postgis-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