Re: Missing DLL after unplaned server stop

From: gbrun <gbrun(at)myopera(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Missing DLL after unplaned server stop
Date: 2011-09-02 10:48:16
Message-ID: op.v06gaqi8yqc6xb@asensio.parc.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

So, some following for people who will go trough this problem!

I tried many things to solve this problem, and after a while, I noticed
that a lot of DLL were missing...

Completely hopeless, I decided to erase my installed PostGreSQL version
with fresh binaries downloaded at this adress:
http://www.postgresql.org/download/windows

Unbelievable: everything has come back! Even my data, because I let their
folder untouched.

So, sometimes, just be brutal...

I think, the problem came from a windows update. I found some posts
related to the same problem, like this one:
http://forums.enterprisedb.com/posts/list/2843.page

Geoffrey

On Fri, 02 Sep 2011 10:09:02 +0200, gbrun <gbrun(at)myopera(dot)com> wrote:

> Hi everybody!
>
> I've encountered a problem similar to this mentioned on this thread:
> http://archives.postgresql.org/pgsql-bugs/2009-12/msg00207.php
>
> I've got the same problem: I'm unable to start PostGreSQL (trough
> PGAdmin or the service itself). Message is: "This application failed to
> start because SSLEAY32.dll was not found. Re-installing the application
> may fix this problem." This problem appeared after an unwilled server
> stop (because of a storm). Nevertheless, I can't be sure my problem is
> related to this stop.
>
> My server is a Windows Server 2008 64 bit. I'm using a PostGreSQL 9.0.4
> version (32 bit), with PostGIS extension 1.5.
>
> So, I looked after the missing dll: I found it into the folder
> "..\PostgreSQL\9.0\bin\postgisgui".
>
> I didn't try to reinstall PostGreSQL because I have some data that I
> would like to get back. Nevertheless, I haven't done any database
> backup... Is there any way to get back data without backup? Or maybe is
> there a way to solve the dll problem without reinstalling PostGreSQL?
>
> Any help would be great! :)
>
> Geoffrey
>

--
Using Opera's revolutionary email client: http://www.opera.com/mail/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Antonio Vieiro 2011-09-02 10:49:10 Re: Memory leak somewhere at PQconnectdb?
Previous Message Rory Campbell-Lange 2011-09-02 10:46:38 Re: UPDATE using query; per-row function calling problem