Re: PostgreSQL 8.0.0-beta4 pginstaller failure on Windows 2003

This one gave me grief also.
The fix turns out to be pretty simple.

libeay32.dll is located in System32 and can be installed by any number of
applications, maybe the most notable being Crystal Reports.

More than likely the version on your machine is not recent enough to have
the required entry point. Mine had version 0.9.6.101.

postgreSQL needs to overwrite the installed version and their installer does the
reponsible thing; it checks to make sure its version of the dll is greater than
the version already installed. This way if a newer version is already installed
postgreSQL wont' overwrite it. The problem is the version information in
postgreSQL's installer's version of libeay32.dll is missing therefore the test
to see if it is a newer version than the currently installed version will always
fail - if there is an existing version installed that is.

That last sentence encapsulates the workaround:
1. Delete libeay32.dll from System32 (actually move it somewhere just in case)
2. Run the postreSQL beta 4 installer which should now properly install the
correct of version of libeay32.dll into System32.

Hope this helps. It worked on two different machines for me.

-tillman-

Tillman Dickson, Jr.
Babcock & Brown

bruce(at)bcat(dot)us (Bruce Patin) wrote in message news:<5(dot)1(dot)1(dot)6(dot)0(dot)20041026124219(dot)00a78dc0(at)bcat(dot)us>...
> I downloaded http://pgfoundry.org/projects/pginstaller/
> and used it to attempt installation of PostgreSQL 8.0.0-beta4
> on a Microsoft Windows Server 2003 Standard Edition.
>
> Things I changed from defaults are the userid "postgresql", instead of
> "postgres",
> and checked box to "Accept connections on all addreses, not just localhost".
> (Note "addreses" in the above label is misspelled, should be "addresses".)
>
> Results:
>
> initdb.exe - Ordinal Not Found
> The ordinal 2821 could not be located in the dynamic link library
> "libeay32.dll" "ordinal 2821".
>
> PostgreSQL 8.0.0-beta4
> Failed to run initdb: 128!
> Please see the logfile in 'C:\Program
> Files\PostgreSQL\8.0.0-beta4\tmp\initdb.log'.
> Note! You must read/copy this logfile before you click OK, or it will be
> automatically removed.
>
> I looked at the logfile before clicking on OK, and it was empty, 0 bytes.
>
> The installation rolled itself back.
>
> Bruce Patin
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings