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

Sat Feb 25 22:57:31 PST 2012

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