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

Thanks for assistance,
Josef Springer

Thanks for assistance,
Josef Springer

• 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)

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

Thanks for assistance,
Josef Springer

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

• Term the Server-Service
• Copying back the backup of the folder data
• Starting the Server-Service (whitch did not)

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

• Term server-service
• Copying back the backup of the folder data
• Starting the server-service (whitch does not start)

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

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

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

• 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"

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

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