Signature

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

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

<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=C3=BCfen"
I must use my existing databases (folder data) !

Can anybody help me ?

=20
Thanks for assistance,
Josef Springer

Hi=C2=A0Josef Springer,=

If you are able to sta= rt the PostgreSQL server manually i.e from pg_ctl then the problem with you= r service.

You can recreate that service with foll= owing command

pg_ctl register =C2=A0[-N SERVICENAME] [-U USER= NAME] [-P PASSWORD] [-D DATADIR]

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

Hope this will resolve your problem.

Thanks & Regards,

Harshad Adalkonda=C2=A0
Database Administrator
http://www.shreeyans= h.com

--001a114701b619c38505104b9a22-- From Josef.Springer@joops.com Thu Mar 5 10:08:37 2015 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YTShp-0003G3-PF for pgsql-admin@arkaria.postgresql.org; Thu, 05 Mar 2015 10:08:37 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YTSho-0005Hi-VE for pgsql-admin@arkaria.postgresql.org; Thu, 05 Mar 2015 10:08:37 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YTShn-0005HX-Qu for pgsql-admin@postgresql.org; Thu, 05 Mar 2015 10:08:35 +0000 Received: from vs0601-ipv6-5.onit4u.de ([2a01:4f8:130:116b::5] helo=vserver0601.onit4u.de) by magus.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YTShg-00029A-8C for pgsql-admin@postgresql.org; Thu, 05 Mar 2015 10:08:34 +0000 X-PDA-ORIGIN: vserver0601.onit4u.de Received: (qmail 29361 invoked from network); 5 Mar 2015 10:08:21 -0000 Received: by simscan 1.4.0 ppid: 29344, pid: 29356, t: 0.4615s scanners: clamav: 0.98.5/m:55/d:20149 Received: from dslb-088-067-009-112.088.067.pools.vodafone-ip.de (HELO ?192.168.2.134?) (Josef.Springer@joops.com@88.67.9.112) by vserver0601.onit4u.de with SMTP; 5 Mar 2015 10:08:21 -0000 Message-ID: <54F82B20.4010906@joops.com> Date: Thu, 05 Mar 2015 11:08:32 +0100 From: Josef Springer User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.2.17) Gecko/20110414 Thunderbird/3.1.10 MIME-Version: 1.0 To: Jan-Peter Seifert CC: Lou Picciano , pgsql-admin@postgresql.org Subject: Re: Installing PostgreSQL fails References: <54F05CBF.5050006@joops.com> <1469279821.239990.1425053551214.JavaMail.zimbra@comcast.net> <54F30147.1020207@joops.com> <54F32306.5020609@gmx.de> In-Reply-To: <54F32306.5020609@gmx.de> Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit X-Pg-Spam-Score: -1.2 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org 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 ...

From Josef.Springer@joops.com Thu Mar 5 10:21:13 2015 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YTSu1-0003kb-0z for pgsql-admin@arkaria.postgresql.org; Thu, 05 Mar 2015 10:21:13 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YTSu0-0000Yb-EB for pgsql-admin@arkaria.postgresql.org; Thu, 05 Mar 2015 10:21:12 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YTStz-0000YR-6R for pgsql-admin@postgresql.org; Thu, 05 Mar 2015 10:21:11 +0000 Received: from vs0601-ipv6-5.onit4u.de ([2a01:4f8:130:116b::5] helo=vserver0601.onit4u.de) by magus.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YTStv-0002Ra-CA for pgsql-admin@postgresql.org; Thu, 05 Mar 2015 10:21:10 +0000 X-PDA-ORIGIN: vserver0601.onit4u.de Received: (qmail 1135 invoked from network); 5 Mar 2015 10:21:02 -0000 Received: by simscan 1.4.0 ppid: 1077, pid: 1105, t: 0.7884s scanners: clamav: 0.98.5/m:55/d:20149 Received: from dslb-088-067-009-112.088.067.pools.vodafone-ip.de (HELO ?192.168.2.134?) (Josef.Springer@joops.com@88.67.9.112) by vserver0601.onit4u.de with SMTP; 5 Mar 2015 10:21:01 -0000 Message-ID: <54F82E18.9050902@joops.com> Date: Thu, 05 Mar 2015 11:21:12 +0100 From: Josef Springer User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.2.17) Gecko/20110414 Thunderbird/3.1.10 MIME-Version: 1.0 To: Harshad Adalkonda CC: Lou Picciano , "pgsql-admin@postgresql.org" Subject: Re: Installing PostgreSQL fails References: <54F05CBF.5050006@joops.com> <1469279821.239990.1425053551214.JavaMail.zimbra@comcast.net> <54F30147.1020207@joops.com> In-Reply-To: Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit X-Pg-Spam-Score: -1.2 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org Hello Harald,

the server-service worked after resinstalling PostgreSQL correctly.
But after coipying back the backup of the folder data, the server-service does not start anymore.
What i have done:

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

So, i assume i missed something copying back, but the server must not be receated.
Do you have any idea ?

Thanks for assistance,
Josef Springer

On 02.03.2015 11:22, Harshad Adalkonda wrote:

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

From Jan-Peter.Seifert@gmx.de Sat Mar 7 00:55:50 2015 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YU31y-0003HF-8q for pgsql-admin@arkaria.postgresql.org; Sat, 07 Mar 2015 00:55:50 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YU31x-0006pc-2u for pgsql-admin@arkaria.postgresql.org; Sat, 07 Mar 2015 00:55:49 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YU31u-0006pN-Uf for pgsql-admin@postgresql.org; Sat, 07 Mar 2015 00:55:47 +0000 Received: from mout.gmx.net ([212.227.17.22]) by magus.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YU31o-00080C-Od for pgsql-admin@postgresql.org; Sat, 07 Mar 2015 00:55:45 +0000 Received: from [192.168.178.22] ([37.4.205.150]) by mail.gmx.com (mrgmx102) with ESMTPSA (Nemesis) id 0LjuR3-1Xt3Ro1D5d-00bolk; Sat, 07 Mar 2015 01:55:37 +0100 Message-ID: <54FA4C88.7050902@gmx.de> Date: Sat, 07 Mar 2015 01:55:36 +0100 From: Jan-Peter Seifert User-Agent: Mozilla/5.0 (Windows NT 6.1; rv:31.0) Gecko/20100101 Thunderbird/31.5.0 MIME-Version: 1.0 To: Josef Springer CC: Lou Picciano , pgsql-admin@postgresql.org Subject: Re: Installing PostgreSQL fails References: <54F05CBF.5050006@joops.com> <1469279821.239990.1425053551214.JavaMail.zimbra@comcast.net> <54F30147.1020207@joops.com> <54F32306.5020609@gmx.de> <54F82B20.4010906@joops.com> In-Reply-To: <54F82B20.4010906@joops.com> Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit X-Provags-ID: V03:K0:0Sn+yuUNjtV1ExEASDihsF/eWUDYClRWeMDafxwApd0P78SBrSf HrLasI3gccmhh1HgP520/5Hh06bZ3PgVkLkt+fPZHafWRhw4+mlnqd+Kk12QQKj1D7OQ/Pp mBmUwuMfABPXoY4hs8PaRldv+xN5UUNgnj1s478fVW19tO7Gw3Mp/8CM+SW1XUMQW3JwYII J7CPv14CXsZ6Ro9Y+g3cg== X-UI-Out-Filterresults: notjunk:1; X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org 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 ... >> >> >> >> > > -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin From Josef.Springer@joops.com Sat Mar 7 10:22:05 2015 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YUBrx-0007Ti-I8 for pgsql-admin@arkaria.postgresql.org; Sat, 07 Mar 2015 10:22:05 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YUBrv-0003zF-NJ for pgsql-admin@arkaria.postgresql.org; Sat, 07 Mar 2015 10:22:03 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YUBru-0003z8-K1 for pgsql-admin@postgresql.org; Sat, 07 Mar 2015 10:22:02 +0000 Received: from vs0601-ipv6-5.onit4u.de ([2a01:4f8:130:116b::5] helo=vserver0601.onit4u.de) by magus.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YUBrr-0001Z0-5d for pgsql-admin@postgresql.org; Sat, 07 Mar 2015 10:22:00 +0000 X-PDA-ORIGIN: vserver0601.onit4u.de Received: (qmail 17839 invoked from network); 7 Mar 2015 10:21:53 -0000 Received: by simscan 1.4.0 ppid: 17822, pid: 17834, t: 0.5741s scanners: clamav: 0.98.5/m:55/d:20158 Received: from dslb-088-067-009-112.088.067.pools.vodafone-ip.de (HELO ?192.168.2.134?) (Josef.Springer@joops.com@88.67.9.112) by vserver0601.onit4u.de with SMTP; 7 Mar 2015 10:21:53 -0000 Message-ID: <54FAD14D.5010606@joops.com> Date: Sat, 07 Mar 2015 11:22:05 +0100 From: Josef Springer User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.2.17) Gecko/20110414 Thunderbird/3.1.10 MIME-Version: 1.0 To: Jan-Peter Seifert CC: Lou Picciano , pgsql-admin@postgresql.org Subject: Re: Installing PostgreSQL fails References: <54F05CBF.5050006@joops.com> <1469279821.239990.1425053551214.JavaMail.zimbra@comcast.net> <54F30147.1020207@joops.com> <54F32306.5020609@gmx.de> <54F82B20.4010906@joops.com> <54FA4C88.7050902@gmx.de> In-Reply-To: <54FA4C88.7050902@gmx.de> Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -1.2 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org Hello Jan,

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 ?

best thanks for your assistance,
Josef Springer

On 07.03.2015 01:55, Jan-Peter Seifert wrote:

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

From Josef.Springer@joops.com Sat Mar 7 11:36:44 2015 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YUD2C-0001Zz-94 for pgsql-admin@arkaria.postgresql.org; Sat, 07 Mar 2015 11:36:44 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YUD2B-0006DN-2b for pgsql-admin@arkaria.postgresql.org; Sat, 07 Mar 2015 11:36:43 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YUD29-0006CO-V5 for pgsql-admin@postgresql.org; Sat, 07 Mar 2015 11:36:42 +0000 Received: from vs0601-ipv6-5.onit4u.de ([2a01:4f8:130:116b::5] helo=vserver0601.onit4u.de) by magus.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YUD22-0002vA-N2 for pgsql-admin@postgresql.org; Sat, 07 Mar 2015 11:36:40 +0000 X-PDA-ORIGIN: vserver0601.onit4u.de Received: (qmail 3822 invoked from network); 7 Mar 2015 11:36:29 -0000 Received: by simscan 1.4.0 ppid: 3806, pid: 3817, t: 0.1741s scanners: clamav: 0.98.5/m:55/d:20158 Received: from dslb-088-067-009-112.088.067.pools.vodafone-ip.de (HELO ?192.168.2.134?) (Josef.Springer@joops.com@88.67.9.112) by vserver0601.onit4u.de with SMTP; 7 Mar 2015 11:36:29 -0000 Message-ID: <54FAE2C9.1090204@joops.com> Date: Sat, 07 Mar 2015 12:36:41 +0100 From: Josef Springer User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.2.17) Gecko/20110414 Thunderbird/3.1.10 MIME-Version: 1.0 CC: pgsql-admin@postgresql.org Subject: Re: Installing PostgreSQL fails References: <54F05CBF.5050006@joops.com> <1469279821.239990.1425053551214.JavaMail.zimbra@comcast.net> <54F30147.1020207@joops.com> <54F32306.5020609@gmx.de> <54F82B20.4010906@joops.com> In-Reply-To: <54F82B20.4010906@joops.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -0.9 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org 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 From Jan-Peter.Seifert@gmx.de Sat Mar 7 16:39:04 2015 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YUHkm-00043n-Kt for pgsql-admin@arkaria.postgresql.org; Sat, 07 Mar 2015 16:39:04 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YUHkm-0000Sc-4i for pgsql-admin@arkaria.postgresql.org; Sat, 07 Mar 2015 16:39:04 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YUHkl-0000SV-0l for pgsql-admin@postgresql.org; Sat, 07 Mar 2015 16:39:03 +0000 Received: from mout.gmx.net ([212.227.17.20]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YUHkh-00060O-7l for pgsql-admin@postgresql.org; Sat, 07 Mar 2015 16:39:01 +0000 Received: from [192.168.178.22] ([37.4.205.150]) by mail.gmx.com (mrgmx103) with ESMTPSA (Nemesis) id 0LiTrM-1Xu7WB1tym-00cerk; Sat, 07 Mar 2015 17:38:51 +0100 Message-ID: <54FB299A.9090501@gmx.de> Date: Sat, 07 Mar 2015 17:38:50 +0100 From: Jan-Peter Seifert User-Agent: Mozilla/5.0 (Windows NT 6.1; rv:31.0) Gecko/20100101 Thunderbird/31.5.0 MIME-Version: 1.0 To: Josef Springer CC: Lou Picciano , pgsql-admin@postgresql.org Subject: Re: Installing PostgreSQL fails References: <54F05CBF.5050006@joops.com> <1469279821.239990.1425053551214.JavaMail.zimbra@comcast.net> <54F30147.1020207@joops.com> <54F32306.5020609@gmx.de> <54F82B20.4010906@joops.com> <54FA4C88.7050902@gmx.de> <54FAD14D.5010606@joops.com> In-Reply-To: <54FAD14D.5010606@joops.com> Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 7bit X-Provags-ID: V03:K0:7zAde+ZbeDt+11Rwo9UY57z3s3gSZpxIkMROnuxGgN90g+O36VS 9YyxcQxBr2o7UtNySx4B4MyG4QmgkDpGwwgAbNa3XtwNL8LkdWU1TxMBvwLGrPNB3NgvJlO byJCYV3yMfIZK6flxQ3/uu4r8kx8fQD8h2AuQuOkhwvBOy6rqcDgGVdrKOv2iNe/+msok4A GcQeMsIdvLCXUIM0IluUA== X-UI-Out-Filterresults: notjunk:1; X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org 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 From Josef.Springer@joops.com Sat Mar 14 13:27:28 2015 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YWm6C-0006zW-S8 for pgsql-admin@arkaria.postgresql.org; Sat, 14 Mar 2015 13:27:28 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YWm6C-0000jq-6R for pgsql-admin@arkaria.postgresql.org; Sat, 14 Mar 2015 13:27:28 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YWm6A-0000jg-4I for pgsql-admin@postgresql.org; Sat, 14 Mar 2015 13:27:26 +0000 Received: from vs0601-ipv6-5.onit4u.de ([2a01:4f8:130:116b::5] helo=vserver0601.onit4u.de) by magus.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YWm61-0005AI-O5 for pgsql-admin@postgresql.org; Sat, 14 Mar 2015 13:27:24 +0000 X-PDA-ORIGIN: vserver0601.onit4u.de Received: (qmail 24548 invoked from network); 14 Mar 2015 13:27:12 -0000 Received: by simscan 1.4.0 ppid: 24521, pid: 24543, t: 0.5575s scanners: clamav: 0.98.6/m:55/d:20194 Received: from dslb-088-067-009-112.088.067.pools.vodafone-ip.de (HELO ?192.168.2.134?) (Josef.Springer@joops.com@88.67.9.112) by vserver0601.onit4u.de with SMTP; 14 Mar 2015 13:27:12 -0000 Message-ID: <55043738.3000500@joops.com> Date: Sat, 14 Mar 2015 14:27:20 +0100 From: Josef Springer User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.2.17) Gecko/20110414 Thunderbird/3.1.10 MIME-Version: 1.0 To: Jan-Peter Seifert CC: Lou Picciano , pgsql-admin@postgresql.org Subject: Re: Installing PostgreSQL fails References: <54F05CBF.5050006@joops.com> <1469279821.239990.1425053551214.JavaMail.zimbra@comcast.net> <54F30147.1020207@joops.com> <54F32306.5020609@gmx.de> <54F82B20.4010906@joops.com> <54FA4C88.7050902@gmx.de> <54FAD14D.5010606@joops.com> <54FB299A.9090501@gmx.de> In-Reply-To: <54FB299A.9090501@gmx.de> Content-Type: text/html; charset=windows-1251 Content-Transfer-Encoding: 8bit X-Pg-Spam-Score: -1.2 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org Hello Peter,

thanks for your hints ! Your information gave me the resolution.
pg_clt start gave me the information about a corrupted postmaster.pid (filesize was 1k, but empty).
So i installed 8.2.1 and copied the folder data backup without postmaster.pid.
And what a suprise, all works perfectly and my databases are back.

Thanks for your assistance,
Josef Springer

On 07.03.2015 17:38, Jan-Peter Seifert wrote:

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