From: Josef Springer <Josef.Springer@joops.com>
To: Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
Cc: Lou Picciano <loupicciano@comcast.net>
Cc: pgsql-admin@postgresql.org
Subject: Re: Installing PostgreSQL fails
Date: Sat, 07 Mar 2015 11:22:05 +0100
Message-ID: <54FAD14D.5010606@joops.com> (raw)
In-Reply-To: <54FA4C88.7050902@gmx.de>
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>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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 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>
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"> * 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
<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>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: Josef.Springer@joops.com, Jan-Peter.Seifert@gmx.de, loupicciano@comcast.net
Subject: Re: Installing PostgreSQL fails
In-Reply-To: <54FAD14D.5010606@joops.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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