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