pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed

Installing PostgreSQL fails
12+ messages / 4 participants
[nested] [flat]

* Installing PostgreSQL fails
@ 2015-02-27 12:02 Josef Springer <Josef.Springer@joops.com>
  2015-02-27 16:12 ` Re: Installing PostgreSQL fails Lou Picciano <loupicciano@comcast.net>
  0 siblings, 1 reply; 12+ messages in thread

From: Josef Springer @ 2015-02-27 12:02 UTC (permalink / raw)
  To: pgsql-admin

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <meta http-equiv="content-type" content="text/html;
      charset=ISO-8859-1">
  </head>
  <body text="#000000" bgcolor="#ffffff">
    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&uuml;fen"<br>
    I must use my existing databases (folder data) !<br>
    <br>
    Can anybody help me ?<br>
    <div class="moz-signature">
      <title>Signature</title>
      <p>Thanks for assistance,<br>
        Josef Springer<br>
      </p>
      <br>
    </div>
  </body>
</html>




^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: Installing PostgreSQL fails
  2015-02-27 12:02 Installing PostgreSQL fails Josef Springer <Josef.Springer@joops.com>
@ 2015-02-27 16:12 ` Lou Picciano <loupicciano@comcast.net>
  2015-03-01 12:08   ` Re: Installing PostgreSQL fails Josef Springer <Josef.Springer@joops.com>
  0 siblings, 1 reply; 12+ messages in thread

From: Lou Picciano @ 2015-02-27 16:12 UTC (permalink / raw)
  To: Josef Springer <Josef.Springer@joops.com>; pgsql-admin

Josef, 

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... 

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. 

But it sounds like you don't have any fundamental problem with PostgreSQL itself; just with SSL. 

Lou Picciano 

----- Original Message -----

From: "Josef Springer" <Josef.Springer@joops.com> 
To: "pgsql-admin" <pgsql-admin@postgresql.org> 
Sent: Friday, February 27, 2015 7:02:07 AM 
Subject: [ADMIN] Installing PostgreSQL fails 

Hello everybody, 

Windows-Vista 32Bit, PostgreSQL 8.2.1 

After the reparation of a bad sector on the disk, the PostgreSQL-Server did not start anymore. 
I decided to reinstall 8.2.1. 
The installer says "LIBEAY32.DLL konnte nicht geladen werden: 193. Das Installationsprogramm kann nicht auf eine passende bereits installierte OpenSLL.Version prüfen" 
I must use my existing databases (folder data) ! 

Can anybody help me ? 
Signature 

Thanks for assistance, 
Josef Springer 

^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: Installing PostgreSQL fails
  2015-02-27 12:02 Installing PostgreSQL fails Josef Springer <Josef.Springer@joops.com>
  2015-02-27 16:12 ` Re: Installing PostgreSQL fails Lou Picciano <loupicciano@comcast.net>
@ 2015-03-01 12:08   ` Josef Springer <Josef.Springer@joops.com>
  2015-03-01 14:32     ` Re: Installing PostgreSQL fails Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
  2015-03-02 10:22     ` Re: Installing PostgreSQL fails Harshad Adalkonda <adalkondaharshad@gmail.com>
  0 siblings, 2 replies; 12+ messages in thread

From: Josef Springer @ 2015-03-01 12:08 UTC (permalink / raw)
  To: Lou Picciano <loupicciano@comcast.net>; +Cc: pgsql-admin

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">
    <title></title>
  </head>
  <body 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<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'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 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">&lt;Josef.Springer@joops.com&gt;</a><br>
          <b>To: </b>"pgsql-admin" <a class="moz-txt-link-rfc2396E" href="mailto:pgsql-admin@postgresql.org">&lt;pgsql-admin@postgresql.org&gt;</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&uuml;fen"<br>
          I must use my existing databases (folder data) !<br>
          <br>
          Can anybody help me ?<br>
          <div class="moz-signature">
            <title>Signature</title>
            <p>Thanks for assistance,<br>
              Josef Springer<br>
            </p>
            <br>
          </div>
        </div>
        <div><br>
        </div>
      </div>
    </blockquote>
    <br>
    <div class="moz-signature"><br>
    </div>
  </body>
</html>




^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: Installing PostgreSQL fails
  2015-02-27 12:02 Installing PostgreSQL fails Josef Springer <Josef.Springer@joops.com>
  2015-02-27 16:12 ` Re: Installing PostgreSQL fails Lou Picciano <loupicciano@comcast.net>
  2015-03-01 12:08   ` Re: Installing PostgreSQL fails Josef Springer <Josef.Springer@joops.com>
@ 2015-03-01 14:32     ` Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
  2015-03-05 10:08       ` Re: Installing PostgreSQL fails Josef Springer <Josef.Springer@joops.com>
  1 sibling, 1 reply; 12+ messages in thread

From: Jan-Peter Seifert @ 2015-03-01 14:32 UTC (permalink / raw)
  To: Josef Springer <Josef.Springer@joops.com>; Lou Picciano <loupicciano@comcast.net>; +Cc: pgsql-admin

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 ...




-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin



^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: Installing PostgreSQL fails
  2015-02-27 12:02 Installing PostgreSQL fails Josef Springer <Josef.Springer@joops.com>
  2015-02-27 16:12 ` Re: Installing PostgreSQL fails Lou Picciano <loupicciano@comcast.net>
  2015-03-01 12:08   ` Re: Installing PostgreSQL fails Josef Springer <Josef.Springer@joops.com>
  2015-03-01 14:32     ` Re: Installing PostgreSQL fails Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
@ 2015-03-05 10:08       ` Josef Springer <Josef.Springer@joops.com>
  2015-03-07 00:55         ` Re: Installing PostgreSQL fails Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
  2015-03-07 11:36         ` Re: Installing PostgreSQL fails Josef Springer <Josef.Springer@joops.com>
  0 siblings, 2 replies; 12+ messages in thread

From: Josef Springer @ 2015-03-05 10:08 UTC (permalink / raw)
  To: Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>; +Cc: Lou Picciano <loupicciano@comcast.net>; pgsql-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 Jan,<br>
    <br>
    the Server-Service  worked after reinstalling PostgreSQL correctly.<br>
    But after copying back the backup of the folder <b>data</b>, the
    Server-Service does not work anymore. <br>
    What i did:<br>
    <ul>
      <li>Term the Server-Service</li>
      <li>Copying back the backup of the folder <b>data</b></li>
      <li>Starting the Server-Service (whitch did not)</li>
    </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-Peter Seifert 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 Windows user postgres so that the
      file privileges are wrong.
      <br>
      IIRC there's a batch file for setting the correct file privileges
      ( 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 Windows again!!!!
      <br>
      <br>
      Good luck ...
      <br>
      <br>
      <br>
      <br>
      <br>
    </blockquote>
    <br>
    <div class="moz-signature"><br>
    </div>
  </body>
</html>




^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: Installing PostgreSQL fails
  2015-02-27 12:02 Installing PostgreSQL fails Josef Springer <Josef.Springer@joops.com>
  2015-02-27 16:12 ` Re: Installing PostgreSQL fails Lou Picciano <loupicciano@comcast.net>
  2015-03-01 12:08   ` Re: Installing PostgreSQL fails Josef Springer <Josef.Springer@joops.com>
  2015-03-01 14:32     ` Re: Installing PostgreSQL fails Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
  2015-03-05 10:08       ` Re: Installing PostgreSQL fails Josef Springer <Josef.Springer@joops.com>
@ 2015-03-07 00:55         ` Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
  2015-03-07 10:22           ` Re: Installing PostgreSQL fails Josef Springer <Josef.Springer@joops.com>
  1 sibling, 1 reply; 12+ messages in thread

From: Jan-Peter Seifert @ 2015-03-07 00:55 UTC (permalink / raw)
  To: Josef Springer <Josef.Springer@joops.com>; +Cc: Lou Picciano <loupicciano@comcast.net>; pgsql-admin

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_... 


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 ...
>>
>>
>>
>>
>
>


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin



^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: Installing PostgreSQL fails
  2015-02-27 12:02 Installing PostgreSQL fails Josef Springer <Josef.Springer@joops.com>
  2015-02-27 16:12 ` Re: Installing PostgreSQL fails Lou Picciano <loupicciano@comcast.net>
  2015-03-01 12:08   ` Re: Installing PostgreSQL fails Josef Springer <Josef.Springer@joops.com>
  2015-03-01 14:32     ` Re: Installing PostgreSQL fails Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
  2015-03-05 10:08       ` Re: Installing PostgreSQL fails Josef Springer <Josef.Springer@joops.com>
  2015-03-07 00:55         ` Re: Installing PostgreSQL fails Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
@ 2015-03-07 10:22           ` Josef Springer <Josef.Springer@joops.com>
  2015-03-07 16:38             ` Re: Installing PostgreSQL fails Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
  0 siblings, 1 reply; 12+ messages in thread

From: Josef Springer @ 2015-03-07 10:22 UTC (permalink / raw)
  To: Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>; +Cc: Lou Picciano <loupicciano@comcast.net>; pgsql-admin

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">
  </head>
  <body text="#000000" bgcolor="#ffffff">
    Hello Jan,<br>
    <br>
    yes, i used the same win-user for installation and the same user
    (default postgres) an password for the server-service.<br>
    <ul>
      <li>Server works after reinstallation.</li>
      <li>I terminate server-service</li>
      <li>I restore backup of folder data </li>
      <li>I start server-service</li>
      <li>Starting of server-service is abandomed with errormessage
        "Fehler 1053 Der Dienst antwortet nicht auf die Start oder
        Steueranweisung"</li>
    </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 user the service has
      been registered to ( default name is postgres ).
      <br>
      Is this really the VERY same user used for the old 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_...;
      <br>
      <br>
      The owner of the service should be a local user and not member of
      a domain.
      <br>
      <br>
      And you should really check Windows' 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&nbsp; 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>
        &nbsp; * Term the Server-Service
        <br>
        &nbsp; * Copying back the backup of the folder *data*
        <br>
        &nbsp; * 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>
        Do you 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">&nbsp; * But starting now
            PostgtreSQL-Server service does not work anymore. I
            <br>
            &nbsp;&nbsp;&nbsp; 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 Windows user postgres so that
          the file
          <br>
          privileges are 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>
  </body>
</html>




^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: Installing PostgreSQL fails
  2015-02-27 12:02 Installing PostgreSQL fails Josef Springer <Josef.Springer@joops.com>
  2015-02-27 16:12 ` Re: Installing PostgreSQL fails Lou Picciano <loupicciano@comcast.net>
  2015-03-01 12:08   ` Re: Installing PostgreSQL fails Josef Springer <Josef.Springer@joops.com>
  2015-03-01 14:32     ` Re: Installing PostgreSQL fails Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
  2015-03-05 10:08       ` Re: Installing PostgreSQL fails Josef Springer <Josef.Springer@joops.com>
  2015-03-07 00:55         ` Re: Installing PostgreSQL fails Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
  2015-03-07 10:22           ` Re: Installing PostgreSQL fails Josef Springer <Josef.Springer@joops.com>
@ 2015-03-07 16:38             ` Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
  2015-03-14 13:27               ` Re: Installing PostgreSQL fails Josef Springer <Josef.Springer@joops.com>
  0 siblings, 1 reply; 12+ messages in thread

From: Jan-Peter Seifert @ 2015-03-07 16:38 UTC (permalink / raw)
  To: Josef Springer <Josef.Springer@joops.com>; +Cc: Lou Picciano <loupicciano@comcast.net>; pgsql-admin

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



-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin



^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: Installing PostgreSQL fails
  2015-02-27 12:02 Installing PostgreSQL fails Josef Springer <Josef.Springer@joops.com>
  2015-02-27 16:12 ` Re: Installing PostgreSQL fails Lou Picciano <loupicciano@comcast.net>
  2015-03-01 12:08   ` Re: Installing PostgreSQL fails Josef Springer <Josef.Springer@joops.com>
  2015-03-01 14:32     ` Re: Installing PostgreSQL fails Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
  2015-03-05 10:08       ` Re: Installing PostgreSQL fails Josef Springer <Josef.Springer@joops.com>
  2015-03-07 00:55         ` Re: Installing PostgreSQL fails Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
  2015-03-07 10:22           ` Re: Installing PostgreSQL fails Josef Springer <Josef.Springer@joops.com>
  2015-03-07 16:38             ` Re: Installing PostgreSQL fails Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
@ 2015-03-14 13:27               ` Josef Springer <Josef.Springer@joops.com>
  0 siblings, 0 replies; 12+ messages in thread

From: Josef Springer @ 2015-03-14 13:27 UTC (permalink / raw)
  To: Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>; +Cc: Lou Picciano <loupicciano@comcast.net>; pgsql-admin

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <meta content="text/html; charset=windows-1251"
      http-equiv="Content-Type">
    <title></title>
  </head>
  <body text="#000000" bgcolor="#ffffff">
    Hello Peter,<br>
    <br>
    thanks for your hints ! Your information gave me the resolution. <br>
    <i>pg_clt start</i> gave me the information about a corrupted
    postmaster.pid (filesize was 1k, but empty).<br>
    So i installed 8.2.1 and copied the 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-service is 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 command line (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...;
      <br>
      <br>
      As soon as you can start up the server successfully stop it again
      (in another command line window or by adding ' &amp;' (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...;
      <br>
      <br>
      Good luck,
      <br>
      <br>
      Peter
      <br>
      <br>
      <br>
      <br>
    </blockquote>
    <br>
    <div class="moz-signature"><br>
    </div>
  </body>
</html>




^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: Installing PostgreSQL fails
  2015-02-27 12:02 Installing PostgreSQL fails Josef Springer <Josef.Springer@joops.com>
  2015-02-27 16:12 ` Re: Installing PostgreSQL fails Lou Picciano <loupicciano@comcast.net>
  2015-03-01 12:08   ` Re: Installing PostgreSQL fails Josef Springer <Josef.Springer@joops.com>
  2015-03-01 14:32     ` Re: Installing PostgreSQL fails Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
  2015-03-05 10:08       ` Re: Installing PostgreSQL fails Josef Springer <Josef.Springer@joops.com>
@ 2015-03-07 11:36         ` Josef Springer <Josef.Springer@joops.com>
  1 sibling, 0 replies; 12+ messages in thread

From: Josef Springer @ 2015-03-07 11:36 UTC (permalink / raw)
  To: ; +Cc: pgsql-admin

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


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin



^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: Installing PostgreSQL fails
  2015-02-27 12:02 Installing PostgreSQL fails Josef Springer <Josef.Springer@joops.com>
  2015-02-27 16:12 ` Re: Installing PostgreSQL fails Lou Picciano <loupicciano@comcast.net>
  2015-03-01 12:08   ` Re: Installing PostgreSQL fails Josef Springer <Josef.Springer@joops.com>
@ 2015-03-02 10:22     ` Harshad Adalkonda <adalkondaharshad@gmail.com>
  2015-03-05 10:21       ` Re: Installing PostgreSQL fails Josef Springer <Josef.Springer@joops.com>
  1 sibling, 1 reply; 12+ messages in thread

From: Harshad Adalkonda @ 2015-03-02 10:22 UTC (permalink / raw)
  To: Josef Springer <Josef.Springer@joops.com>; +Cc: Lou Picciano <loupicciano@comcast.net>; pgsql-admin

On Sun, Mar 1, 2015 at 5:38 PM, Josef Springer <Josef.Springer@joops.com>
wrote:

>  Hello Lou,
>
> much thanks for you tip !!!
> 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.
> But now i have a last problem related to PostgreSQL:
> To keep my databases, i made a copy of the hole PostgreSQL-Folder before
> reinstallation (PostgtreSQL-Server service was not running).
>
>    - I cleared the folder *data*, because the PostgreSQL installation
>    adviced me to do.
>    - I installed PostgreSQL 8.2.1
>    - After installation PostgtreSQL-Server service was running and i
>    could start PGAdminIII.
>    - I stopped the PostgtreSQL-Server service
>    - I restored the backup of the folder *data *(to get my databases back)
>    - 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 ?
>
> Thanks for your assistance,
> Josef Springer
>
>
> On 27.02.2015 17:12, Lou Picciano wrote:
>
>  Josef,
>
>  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...
>
>  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.
>
>  But it sounds like you don't have any fundamental problem with
> PostgreSQL itself; just with SSL.
>
>  Lou Picciano
>
>  ------------------------------
> *From: *"Josef Springer" <Josef.Springer@joops.com>
> <Josef.Springer@joops.com>
> *To: *"pgsql-admin" <pgsql-admin@postgresql.org>
> <pgsql-admin@postgresql.org>
> *Sent: *Friday, February 27, 2015 7:02:07 AM
> *Subject: *[ADMIN] Installing PostgreSQL fails
>
>  Hello everybody,
>
> Windows-Vista 32Bit, PostgreSQL 8.2.1
>
> After the reparation of a bad sector on the disk, the PostgreSQL-Server
> did not start anymore.
> I decided to reinstall 8.2.1.
> The installer says "LIBEAY32.DLL konnte nicht geladen werden: 193. Das
> Installationsprogramm kann nicht auf eine passende bereits installierte
> OpenSLL.Version prüfen"
> I must use my existing databases (folder data) !
>
> Can anybody help me ?
>
> Thanks for assistance,
> Josef Springer
>
>
>
>
>
Hi Josef Springer,

If you are able to start the PostgreSQL server manually i.e from pg_ctl
then the problem with your service.

You can recreate that service with following command

pg_ctl register  [-N SERVICENAME] [-U USERNAME] [-P PASSWORD] [-D DATADIR]

after creating service try to start the service you have created it will
start your database server.

Hope this will resolve your problem.

--

Thanks & Regards,

Harshad Adalkonda
Database Administrator
http://www.shreeyansh.com

^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: Installing PostgreSQL fails
  2015-02-27 12:02 Installing PostgreSQL fails Josef Springer <Josef.Springer@joops.com>
  2015-02-27 16:12 ` Re: Installing PostgreSQL fails Lou Picciano <loupicciano@comcast.net>
  2015-03-01 12:08   ` Re: Installing PostgreSQL fails Josef Springer <Josef.Springer@joops.com>
  2015-03-02 10:22     ` Re: Installing PostgreSQL fails Harshad Adalkonda <adalkondaharshad@gmail.com>
@ 2015-03-05 10:21       ` Josef Springer <Josef.Springer@joops.com>
  0 siblings, 0 replies; 12+ messages in thread

From: Josef Springer @ 2015-03-05 10:21 UTC (permalink / raw)
  To: Harshad Adalkonda <adalkondaharshad@gmail.com>; +Cc: Lou Picciano <loupicciano@comcast.net>; pgsql-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">&lt;<a moz-do-not-send="true"
                href="mailto:Josef.Springer@joops.com" target="_blank">Josef.Springer@joops.com</a>&gt;</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">&lt;Josef.Springer@joops.com&gt;</a><br>
                          <b>To: </b>"pgsql-admin" <a
                            moz-do-not-send="true"
                            href="mailto:pgsql-admin@postgresql.org"
                            target="_blank">&lt;pgsql-admin@postgresql.org&gt;</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 &amp; 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>




^ permalink  raw  reply  [nested|flat] 12+ messages in thread

end of thread, other threads:[~2015-03-14 13:27 UTC | newest]

Thread overview: 12+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2015-02-27 12:02 Installing PostgreSQL fails Josef Springer <Josef.Springer@joops.com>
2015-02-27 16:12 ` Lou Picciano <loupicciano@comcast.net>
2015-03-01 12:08   ` Josef Springer <Josef.Springer@joops.com>
2015-03-01 14:32     ` Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
2015-03-05 10:08       ` Josef Springer <Josef.Springer@joops.com>
2015-03-07 00:55         ` Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
2015-03-07 10:22           ` Josef Springer <Josef.Springer@joops.com>
2015-03-07 16:38             ` Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
2015-03-14 13:27               ` Josef Springer <Josef.Springer@joops.com>
2015-03-07 11:36         ` Josef Springer <Josef.Springer@joops.com>
2015-03-02 10:22     ` Harshad Adalkonda <adalkondaharshad@gmail.com>
2015-03-05 10:21       ` Josef Springer <Josef.Springer@joops.com>

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