Обсуждение: Installing PostgreSQL fails

Hello everybody,<br /><br /> Windows-Vista 32Bit, PostgreSQL 8.2.1<br /><br /> After the reparation of a bad sector on
thedisk, the PostgreSQL-Server did not start anymore.<br /> I decided to reinstall 8.2.1.<br /> The installer says
"LIBEAY32.DLLkonnte nicht geladen werden: 193. Das Installationsprogramm kann nicht auf eine passende bereits
installierteOpenSLL.Version prüfen"<br /> I must use my existing databases (folder data) !<br /><br /> Can anybody help
me?<br /><div class="moz-signature"></div><p>Thanks for assistance,<br /> Josef Springer<br /><br /> 

Thanks for assistance,
Josef Springer

Hello Lou,<br /><br /> much thanks for you tip !!!<br /> I found on the web the tool DLL-Files Fixer. This installed
myLIBEAX32.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-Serverservice was not running).<br /><ul><li>I cleared the folder <b>data</b>, because the PostgreSQL
installationadviced me to do.<li>I installed PostgreSQL 8.2.1<li>After installation PostgtreSQL-Server service was
runningand i could start PGAdminIII.<li>I stopped the PostgtreSQL-Server service <li>I restored the backup of the
folder<b>data </b>(to get my databases back)<li>But starting now PostgtreSQL-Server service does not work anymore. I
getan error message after a while (Error 1053)</ul> Do you have any tips how i can get my databases back ?<br /><br />
Thanksfor your assistance,<br /> Josef Springer<br /><br /> On 27.02.2015 17:12, Lou Picciano wrote: <blockquote
cite="mid:1469279821.239990.1425053551214.JavaMail.zimbra@comcast.net"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'regetting a sort of non-PostgreSQL error message there. LIBEAY32.DLL is part of the DLL dependency chain required
forPostgreSQL's SSL 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 id="zwchr" /><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 class="moz-txt-link-rfc2396E"
href="mailto:Josef.Springer@joops.com"><Josef.Springer@joops.com></a><br/><b>To: </b>"pgsql-admin" <a
class="moz-txt-link-rfc2396E"href="mailto:pgsql-admin@postgresql.org"><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
ofa bad sector on the disk, the PostgreSQL-Server did not start anymore.<br /> I decided to reinstall 8.2.1.<br /> The
installersays "LIBEAY32.DLL konnte nicht geladen werden: 193. Das Installationsprogramm kann nicht auf eine passende
bereitsinstallierte OpenSLL.Version prüfen"<br /> I must use my existing databases (folder data) !<br /><br /> Can
anybodyhelp me ?<br /><div class="moz-signature"></div></div></div></blockquote><p>Thanks for assistance,<br /> Josef
Springer<br/><br /><div><br /></div><br /><div class="moz-signature"><br /></div> 

Am 01.03.2015 um 13:08 schrieb Josef Springer:

>   * But starting now PostgtreSQL-Server service does not work anymore. I
>     get an error message after a while (Error 1053)
>
> Do you have any tips how i can get my databases back ?

Look into the Windows event log for more info.
I guess you also recreated the Windows user postgres so that the file
privileges are wrong.
IIRC there's a batch file for setting the correct file privileges (
don't recall the name) within the PostgreSQL installation folder.
Beware - if you specify the wrong path you might not be able to start
Windows again!!!!

Good luck ...

Hello Jan,<br /><br /> the Server-Service  worked after reinstalling PostgreSQL correctly.<br /> But after copying
backthe backup of the folder <b>data</b>, the Server-Service does not work anymore. <br /> What i did:<br
/><ul><li>Termthe Server-Service<li>Copying back the backup of the folder <b>data</b><li>Starting the Server-Service
(whitchdid not)</ul> So, i assume copying back the folder <b>data</b> is not enought. Something is missing from the
backup?<br /><br /> Do you have any tips for me, thanks,<br /> Josef Springer<br /><br /> On 01.03.2015 15:32,
Jan-PeterSeifert wrote: <blockquote cite="mid:54F32306.5020609@gmx.de" type="cite">Am 01.03.2015 um 13:08 schrieb Josef
Springer:<br /><br /><blockquote type="cite">  * But starting now PostgtreSQL-Server service does not work anymore. I
<br/>     get an error message after a while (Error 1053) <br /><br /> Do you have any tips how i can get my databases
back? <br /></blockquote><br /> Look into the Windows event log for more info. <br /> I guess you also recreated the
Windowsuser postgres so that the file privileges are wrong. <br /> IIRC there's a batch file for setting the correct
fileprivileges ( don't recall the name) within the PostgreSQL installation folder. <br /> Beware - if you specify the
wrongpath you might not be able to start Windows again!!!! <br /><br /> Good luck ... <br /><br /><br /><br /><br
/></blockquote><br/><div class="moz-signature"><br /></div> 

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> 

Hello Josef,

open services (services.msc) and check which user the service has been
registered to ( default name is postgres ).
Is this really the VERY same user used for the old instance?
If not he has a different ID and has to be given the necessary file
permissions:

http://wiki.postgresql.org/wiki/Running_%26_Installing_PostgreSQL_On_Native_Windows#What_filesystem_permissions_does_PostgreSQL_require.3F



The owner of the service should be a local user and not member of a domain.

And you should really check Windows' event log for the error messages
during service startup.

Good luck!

Peter

Am 05.03.2015 um 11:08 schrieb Josef Springer:
> Hello Jan,
>
> the Server-Service  worked after reinstalling PostgreSQL correctly.
> But after copying back the backup of the folder *data*, the
> Server-Service does not work anymore.
> What i did:
>
>   * Term the Server-Service
>   * Copying back the backup of the folder *data*
>   * Starting the Server-Service (whitch did not)
>
> So, i assume copying back the folder *data* is not enought. Something is
> missing from the backup ?
>
> Do you have any tips for me, thanks,
> Josef Springer
>
> On 01.03.2015 15:32, Jan-Peter Seifert wrote:
>> Am 01.03.2015 um 13:08 schrieb Josef Springer:
>>
>>>   * But starting now PostgtreSQL-Server service does not work anymore. I
>>>     get an error message after a while (Error 1053)
>>>
>>> Do you have any tips how i can get my databases back ?
>>
>> Look into the Windows event log for more info.
>> I guess you also recreated the Windows user postgres so that the file
>> privileges are wrong.
>> IIRC there's a batch file for setting the correct file privileges (
>> don't recall the name) within the PostgreSQL installation folder.
>> Beware - if you specify the wrong path you might not be able to start
>> Windows again!!!!
>>
>> Good luck ...
>>
>>
>>
>>
>
>

Hello Jan,<br /><br /> yes, i used the same win-user for installation and the same user (default postgres) an password
forthe server-service.<br /><ul><li>Server works after reinstallation.<li>I terminate server-service<li>I restore
backupof folder data <li>I start server-service<li>Starting of server-service is abandomed with errormessage "Fehler
1053Der Dienst antwortet nicht auf die Start oder Steueranweisung"</ul> Any ideas ?<br /><br /> best thanks for your
assistance,<br/> Josef Springer<br /><br /><br /> On 07.03.2015 01:55, Jan-Peter Seifert wrote: <blockquote
cite="mid:54FA4C88.7050902@gmx.de"type="cite">Hello Josef, <br /><br /> open services (services.msc) and check which
userthe service has been registered to ( default name is postgres ). <br /> Is this really the VERY same user used for
theold instance? <br /> If not he has a different ID and has to be given the necessary file permissions: <br /><a
class="moz-txt-link-freetext"
href="http://wiki.postgresql.org/wiki/Running_%26_Installing_PostgreSQL_On_Native_Windows#What_filesystem_permissions_does_PostgreSQL_require.3F">http://wiki.postgresql.org/wiki/Running_%26_Installing_PostgreSQL_On_Native_Windows#What_filesystem_permissions_does_PostgreSQL_require.3F</a><br
/><br/> The owner of the service should be a local user and not member of a domain. <br /><br /> And you should really
checkWindows' event log for the error messages during service startup. <br /><br /> Good luck! <br /><br /> Peter <br
/><br/> Am 05.03.2015 um 11:08 schrieb Josef Springer: <br /><blockquote type="cite">Hello Jan, <br /><br /> the
Server-Service worked after reinstalling PostgreSQL correctly. <br /> But after copying back the backup of the folder
*data*,the <br /> Server-Service does not work anymore. <br /> What i did: <br /><br />   * Term the Server-Service <br
/>  * Copying back the backup of the folder *data* <br />   * Starting the Server-Service (whitch did not) <br /><br />
So,i assume copying back the folder *data* is not enought. Something is <br /> missing from the backup ? <br /><br />
Doyou have any tips for me, thanks, <br /> Josef Springer <br /><br /> On 01.03.2015 15:32, Jan-Peter Seifert wrote:
<br/><blockquote type="cite">Am 01.03.2015 um 13:08 schrieb Josef Springer: <br /><br /><blockquote type="cite">  * But
startingnow PostgtreSQL-Server service does not work anymore. I <br />     get an error message after a while (Error
1053)<br /><br /> Do you have any tips how i can get my databases back ? <br /></blockquote><br /> Look into the
Windowsevent log for more info. <br /> I guess you also recreated the Windows user postgres so that the file <br />
privilegesare wrong. <br /> IIRC there's a batch file for setting the correct file privileges ( <br /> don't recall the
name)within the PostgreSQL installation folder. <br /> Beware - if you specify the wrong path you might not be able to
start<br /> Windows again!!!! <br /><br /> Good luck ... <br /><br /><br /><br /><br /></blockquote><br /><br
/></blockquote><br/><br /></blockquote><br /><div class="moz-signature"><br /></div> 

Hello Everybody,

i have a backup of a previous PostgreSQL-Installation 8.2.1.
How can i import the databases located in this "data" folder into a
running PostgreSQL-Server ?
Th previous PostgreSQL-Installation and the current one are the same
version 8.2.1.

Thanks for any assistance,
Josef Springer

Am 07.03.2015 um 11:22 schrieb Josef Springer:

> yes, i used the same win-user for installation and the same user
> (default postgres) an password for the server-service.
>
>   * Server works after reinstallation.
>   * I terminate server-service
>   * I restore backup of folder data
>   * I start server-service
>   * Starting of server-service is abandomed with errormessage "Fehler
>     1053 Der Dienst antwortet nicht auf die Start oder Steueranweisung"
>
> Any ideas ?

Hello Josef,

try to start it from command line (as user postgres!):
http://www.postgresql.org/docs/8.2/static/app-pg-ctl.html

As soon as you can start up the server successfully stop it again (in
another command line window or by adding ' &' (no quotes) at the end of
the command).

Then you can add a new service by using the pg_ctl option register.

You can remove the old one by using 'sc delete':
https://technet.microsoft.com/de-de/library/cc742045(v=ws.10).aspx

Good luck,

Peter

Hello Peter,<br /><br /> thanks for your hints ! Your information gave me the resolution. <br /><i>pg_clt start</i>
gaveme the information about a corrupted postmaster.pid (filesize was 1k, but empty).<br /> So i installed 8.2.1 and
copiedthe folder data backup without postmaster.pid.<br /> And what a suprise, all works perfectly and my databases are
back.<br/><br /> Thanks for your assistance,<br /> Josef Springer<br /><br /> On 07.03.2015 17:38, Jan-Peter Seifert
wrote:<blockquote cite="mid:54FB299A.9090501@gmx.de" type="cite">Am 07.03.2015 um 11:22 schrieb Josef Springer: <br
/><br/><blockquote type="cite">yes, i used the same win-user for installation and the same user <br /> (default
postgres)an password for the server-service. <br /><br />   * Server works after reinstallation. <br />   * I terminate
server-service<br />   * I restore backup of folder data <br />   * I start server-service <br />   * Starting of
server-serviceis abandomed with errormessage "Fehler <br />     1053 Der Dienst antwortet nicht auf die Start oder
Steueranweisung"<br /><br /> Any ideas ? <br /></blockquote><br /> Hello Josef, <br /><br /> try to start it from
commandline (as user postgres!): <br /><a class="moz-txt-link-freetext"
href="http://www.postgresql.org/docs/8.2/static/app-pg-ctl.html">http://www.postgresql.org/docs/8.2/static/app-pg-ctl.html</a><br
/><br/> As soon as you can start up the server successfully stop it again (in another command line window or by adding
'&' (no quotes) at the end of the command). <br /><br /> Then you can add a new service by using the pg_ctl option
register.<br /><br /> You can remove the old one by using 'sc delete': <br /><a class="moz-txt-link-freetext"
href="https://technet.microsoft.com/de-de/library/cc742045(v=ws.10).aspx">https://technet.microsoft.com/de-de/library/cc742045(v=ws.10).aspx</a><br
/><br/> Good luck, <br /><br /> Peter <br /><br /><br /><br /></blockquote><br /><div class="moz-signature"><br
/></div>