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

Sun Feb 26 05:06:13 PST 2012

Hi,

ok I checked the ports and they were all ok - in fact I deinstalled
the other postgresql installations on the server. Now the
template_postgis gets created but I have the same error as before that
the postgis-1.5.dll can´t be loaded.

I ran also the batch file that I downloaded from the postgis site but
the geometry and spatial_ref_sys tables don´t get created (I only see
lots of error messages). I also checked that the referenced files are
in the bin-folder (libgeos_c-1.dll, libgeos-3-3-2.dll,
libproj.dll,libiconv-2.dll, libxml-2-2.dll) and indeed they are but
why can´t the dependencywalk program find them (see attached file)? If
I copy them to the lib-folder they get found but then I have other
dependencies that are missing - the same is true if I copy the
postgis-1.5.dll to the bin-folder. But I guess the should be
separately?

I have no glue what I should do now ... Thanks for your help.

2012/2/26 Paragon Corporation <lr at 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-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
>>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
-------------- next part --------------
A non-text attachment was scrubbed...
Name: depencies.jpg
Type: image/jpeg
Size: 546666 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120226/09166b3a/attachment.jpg>