Re: Installing PostgreSQL fails - Mailing list pgsql-admin

From Josef Springer
Subject Re: Installing PostgreSQL fails
Date
Msg-id 54F82E18.9050902@joops.com
Whole thread Raw
In response to Re: Installing PostgreSQL fails  (Harshad Adalkonda <adalkondaharshad@gmail.com>)
List pgsql-admin
Hello Harald,<br /><br /> the server-service worked after resinstalling PostgreSQL correctly.<br /> But after coipying
backthe backup of the folder <b>data</b>, the server-service does not start anymore.<br /> What i have done:<br
/><ul><li>Termserver-service<li>Copying back the backup of the folder <b>data</b><li>Starting the server-service
(whitchdoes not start)</ul> So, i assume i missed something copying back, but the server must not be receated.<br /> Do
youhave any idea ?<br /><br /> Thanks for assistance,<br /> Josef Springer<br /><br /><br /> On 02.03.2015 11:22,
HarshadAdalkonda wrote: <blockquote cite="mid:CANnQH_jkLjnN+byqD9WDyMNfP3Bb+X54jLvi_gfxoHLECEPw8A@mail.gmail.com"
type="cite"><divdir="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
/></span></div></div></div><divclass="gmail_quote">On Sun, Mar 1, 2015 at 5:38 PM, Josef Springer <span
dir="ltr"><<ahref="mailto:Josef.Springer@joops.com" moz-do-not-send="true"
target="_blank">Josef.Springer@joops.com</a>></span>wrote:<br /><blockquote class="gmail_quote" style="margin: 0px
0px0px             0.8ex; border-left: 1px solid rgb(204, 204, 204);             padding-left: 1ex;"><div
bgcolor="#ffffff"text="#000000"> Hello Lou,<br /><br /> much thanks for you tip !!!<br /> I found on the web the tool
DLL-FilesFixer. This installed my LIBEAX32.dll and i was able to do a reinstall of PostgreSQL 8.2.1. <br /> But now i
havea last problem related to PostgreSQL:<br /> To keep my databases, i made a copy of the hole PostgreSQL-Folder
beforereinstallation (PostgtreSQL-Server service was not running).<br /><ul><li>I cleared the folder <b>data</b>,
becausethe PostgreSQL installation adviced me to do.<li>I installed PostgreSQL 8.2.1<li>After installation
PostgtreSQL-Serverservice was running and i could start PGAdminIII.<li>I stopped the PostgtreSQL-Server service <li>I
restoredthe backup of the folder <b>data </b>(to get my databases back)<li>But starting now PostgtreSQL-Server service
doesnot work anymore. I get an error message after a while (Error 1053)</ul> Do you have any tips how i can get my
databasesback ?<br /><br /> Thanks for your assistance,<br /> Josef Springer <div><div class="h5"><br /><br /> On
27.02.201517: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
gettinga sort of non-PostgreSQL error message there. LIBEAY32.DLL is part of the DLL dependency chain required for
PostgreSQL'sSSL support. (This DLL may have been the file damaged by your drive sector errors?) You may be able to
solveyour problems simply by replacing this file...</div><div><br /></div><div>Meanwhile, if you need to recover data -
andif you can be assured of a secure, perhaps local-only(?) client connection to your cluster: Would be to turn off SSL
inpostgresql.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;
justwith 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
href="mailto:Josef.Springer@joops.com"moz-do-not-send="true" target="_blank"><Josef.Springer@joops.com></a><br
/><b>To:</b>"pgsql-admin" <a href="mailto:pgsql-admin@postgresql.org" moz-do-not-send="true"
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
startanymore.<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
usemy existing databases (folder data) !<br /><br /> Can anybody help me ?<br /><div><p>Thanks for assistance,<br />
JosefSpringer<br /><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
tostart the PostgreSQL server manually i.e from pg_ctl then the problem with your service.</div><div><br
/></div><div>Youcan 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
createdit 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><pstyle="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 href="http://www.shreeyansh.com/" moz-do-not-send="true" style="color: rgb(246, 155, 7);"
target="_blank">http://www.shreeyansh.com</a></div></div></div></div></div></div></blockquote><br/><div
class="moz-signature"><br/></div> 

pgsql-admin by date:

Previous
From: Josef Springer
Date:
Subject: Re: Installing PostgreSQL fails
Next
From: Jan-Peter Seifert
Date:
Subject: Re: Installing PostgreSQL fails