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

Paragon Corporation lr at pcorp.us
Sun Feb 26 15:58:22 PST 2012 

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
>

More information about the postgis-users mailing list