From: Josef Springer <Josef.Springer@joops.com>
To: Harshad Adalkonda <adalkondaharshad@gmail.com>
Cc: Lou Picciano <loupicciano@comcast.net>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Installing PostgreSQL fails
Date: Thu, 05 Mar 2015 11:21:12 +0100
Message-ID: <54F82E18.9050902@joops.com> (raw)
In-Reply-To: <CANnQH_jkLjnN+byqD9WDyMNfP3Bb+X54jLvi_gfxoHLECEPw8A@mail.gmail.com>
References: <54F05CBF.5050006@joops.com>
<1469279821.239990.1425053551214.JavaMail.zimbra@comcast.net>
<54F30147.1020207@joops.com>
<CANnQH_jkLjnN+byqD9WDyMNfP3Bb+X54jLvi_gfxoHLECEPw8A@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#ffffff">
Hello Harald,<br>
<br>
the server-service worked after resinstalling PostgreSQL correctly.<br>
But after coipying back the backup of the folder <b>data</b>, the
server-service does not start anymore.<br>
What i have done:<br>
<ul>
<li>Term server-service</li>
<li>Copying back the backup of the folder <b>data</b></li>
<li>Starting the server-service (whitch does not start)</li>
</ul>
So, i assume i missed something copying back, but the server must
not be receated.<br>
Do you have any idea ?<br>
<br>
Thanks for assistance,<br>
Josef Springer<br>
<br>
<br>
On 02.03.2015 11:22, Harshad Adalkonda wrote:
<blockquote
cite="mid:CANnQH_jkLjnN+byqD9WDyMNfP3Bb+X54jLvi_gfxoHLECEPw8A@mail.gmail.com"
type="cite">
<div dir="ltr">
<div class="gmail_extra">
<div>
<div class="gmail_signature">
<div dir="ltr"><span>
<p style="font-family: Helvetica,Arial,sans-serif;
font-size: 12px; line-height: 14px;"><br>
</p>
</span></div>
</div>
</div>
<div class="gmail_quote">On Sun, Mar 1, 2015 at 5:38 PM, Josef
Springer <span dir="ltr"><<a moz-do-not-send="true"
href="mailto:Josef.Springer@joops.com" target="_blank">Josef.Springer@joops.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin: 0px 0px 0px
0.8ex; border-left: 1px solid rgb(204, 204, 204);
padding-left: 1ex;">
<div text="#000000" bgcolor="#ffffff"> Hello Lou,<br>
<br>
much thanks for you tip !!!<br>
I found on the web the tool DLL-Files Fixer. This
installed my LIBEAX32.dll and i was able to do a
reinstall of PostgreSQL 8.2.1. <br>
But now i have a last problem related to PostgreSQL:<br>
To keep my databases, i made a copy of the hole
PostgreSQL-Folder before reinstallation
(PostgtreSQL-Server service was not running).<br>
<ul>
<li>I cleared the folder <b>data</b>, because the
PostgreSQL installation adviced me to do.</li>
<li>I installed PostgreSQL 8.2.1</li>
<li>After installation PostgtreSQL-Server service was
running and i could start PGAdminIII.</li>
<li>I stopped the PostgtreSQL-Server service </li>
<li>I restored the backup of the folder <b>data </b>(to
get my databases back)</li>
<li>But starting now PostgtreSQL-Server service does
not work anymore. I get an error message after a
while (Error 1053)</li>
</ul>
Do you have any tips how i can get my databases back ?<br>
<br>
Thanks for your assistance,<br>
Josef Springer
<div>
<div class="h5"><br>
<br>
On 27.02.2015 17:12, Lou Picciano wrote:
<blockquote type="cite">
<div style="font-family: Verdana; font-size: 12pt;
color: rgb(0, 0, 0);">
<div>Josef,<br>
</div>
<div><br>
</div>
<div>Though my German is weak(!), you're getting
a sort of non-PostgreSQL error message there.
LIBEAY32.DLL is part of the DLL dependency
chain required for PostgreSQL's SSL support.
(This DLL may have been the file damaged by
your drive sector errors?) You may be able to
solve your problems simply by replacing this
file...</div>
<div><br>
</div>
<div>Meanwhile, if you need to recover data -
and if you can be assured of a secure, perhaps
local-only(?) client connection to your
cluster: Would be to turn off SSL in
postgresql.conf. Of course, you'd want to also
restrict access to the cluster with the data
thus exposed.</div>
<div><br>
</div>
<div>But it sounds like you don't have any
fundamental problem with PostgreSQL itself;
just with SSL.</div>
<div><br>
</div>
<div>Lou Picciano</div>
<div><br>
</div>
<hr>
<div style="color: rgb(0, 0, 0); font-weight:
normal; font-style: normal; text-decoration:
none; font-family: Helvetica,Arial,sans-serif;
font-size: 12pt;"><b>From: </b>"Josef
Springer" <a moz-do-not-send="true"
href="mailto:Josef.Springer@joops.com"
target="_blank"><Josef.Springer@joops.com></a><br>
<b>To: </b>"pgsql-admin" <a
moz-do-not-send="true"
href="mailto:pgsql-admin@postgresql.org"
target="_blank"><pgsql-admin@postgresql.org></a><br>
<b>Sent: </b>Friday, February 27, 2015
7:02:07 AM<br>
<b>Subject: </b>[ADMIN] Installing PostgreSQL
fails<br>
<div><br>
</div>
Hello everybody,<br>
<br>
Windows-Vista 32Bit, PostgreSQL 8.2.1<br>
<br>
After the reparation of a bad sector on the
disk, the PostgreSQL-Server did not start
anymore.<br>
I decided to reinstall 8.2.1.<br>
The installer says "LIBEAY32.DLL konnte nicht
geladen werden: 193. Das Installationsprogramm
kann nicht auf eine passende bereits
installierte OpenSLL.Version prüfen"<br>
I must use my existing databases (folder data)
!<br>
<br>
Can anybody help me ?<br>
<div>
<p>Thanks for assistance,<br>
Josef Springer<br>
</p>
<br>
</div>
</div>
<div><br>
</div>
</div>
</blockquote>
<br>
<div><br>
</div>
</div>
</div>
</div>
</blockquote>
</div>
<br>
</div>
<div class="gmail_extra">Hi <span style="font-size: 12.8px;
white-space: nowrap;">Josef Springer</span>,</div>
<div class="gmail_extra">
<div><br>
</div>
<div>If you are able to start the PostgreSQL server manually
i.e from pg_ctl then the problem with your service.</div>
<div><br>
</div>
<div>You can recreate that service with following command</div>
<div><br>
pg_ctl register [-N SERVICENAME] [-U USERNAME] [-P
PASSWORD] [-D DATADIR]</div>
<div><br>
</div>
<div>after creating service try to start the service you have
created it will start your database server.</div>
<div><br>
</div>
<div>Hope this will resolve your problem.</div>
<div><br>
</div>
<div>--</div>
<div>
<div>
<div class="gmail_signature">
<div dir="ltr">
<p style="font-family: Helvetica,Arial,sans-serif;
font-size: 12px; line-height: 14px;"><font
color="#000000">Thanks & Regards,</font></p>
<p style="color: rgb(153, 153, 153); font-family:
Helvetica,Arial,sans-serif; font-size: 12px;
line-height: 14px;"><span style="font-weight: bold;
color: rgb(21, 25, 213);">Harshad Adalkonda</span> <br>
<span style="color: rgb(21, 25, 213);">Database
Administrator</span><br>
<a moz-do-not-send="true"
href="http://www.shreeyansh.com/"; target="_blank"
style="color: rgb(246, 155, 7);">http://www.shreeyansh.com</a></p;
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
<br>
<div class="moz-signature"><br>
</div>
</body>
</html>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: Josef.Springer@joops.com, adalkondaharshad@gmail.com, loupicciano@comcast.net
Subject: Re: Installing PostgreSQL fails
In-Reply-To: <54F82E18.9050902@joops.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox