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

Sun Feb 26 20:30:18 PST 2012

Dear Regina,

thank you very much for your help. Now it works again - I also could
install postgis with the stackbuilder again with no problems (before
that I was already able to view and dump my database also again with
no problems).

It seems restarting the service was the key - too bad I didn´t thought
about that earlier but as the database itself was running fine (and
only the tables with the geography datatype were not working), I
didn´t thought that would be the problem. The only other thing I did
was to put the bin-/lib-folder in the PATH variable but I guess that
doesn´t make a difference.

Btw I did restart it through the windows menu as restarting the
service with the console led to a 1063 error. Anyway it works now -
though I am still not sure what caused the problem in the first place.

Best
Sebastian

2012/2/27 Paragon Corporation <lr at pcorp.us>:
> Sebastian,
> That shouldn't matter.  That just affects what you see in pgAdmin.
> As far as dependency walker goes those errors are fine since the lib becomes
> part of path when postgresql launches so it can find it then.
>
> Only other thoughts
>
> 1) is to look in the pg_log folder in your data folder at the error.  That
> sometimes gives more clues.
> 2) In your services, verify the executable and data path are what you think
> they aree.
>
> For example our 9.1 services path to executable looks like this when we go
> to control -> Services
>
> C:/Program Files (x86)/PostgreSQL/9.1/bin/pg_ctl.exe runservice -N
> "postgresql-9.1" -D "E:/PGData91X32" -w
>
>
> 3) Shut off the service and try to start postgres from the console instead
> of the service
>  use pg_ctl -D path to your data folder.
> e.g.
>
> "C:/Program Files (x86)/PostgreSQL/9.1/bin/pg_ctl.exe" -D "E:/PGData91X32"
> -w
>
> You also want to check your postgresql.conf file that is located in your
> datafolder to make sure it is listening on the port you think it is.
>
> Aside from that its really hard to diagnose without seeing your computer.
>
> 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: Sunday, February 26, 2012 8:24 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
>>
>> Mmmhhh maybe another thing: I also checked the registry and
>> under HKEY_CURRENT_USER\Software\pgAdmin III\Servers I find
>> three identical server 1, 2 and 3 with the exact same
>> databases. Is that correct? But maybe that has nothing to do
>> with the error message I get ...
>>
>>
>> 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
>> _______________________________________________
>> 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