Re: Installing PostgreSQL fails

From: Josef Springer <Josef(dot)Springer(at)joops(dot)com>
To: Jan-Peter Seifert <Jan-Peter(dot)Seifert(at)gmx(dot)de>
Cc: Lou Picciano <loupicciano(at)comcast(dot)net>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Installing PostgreSQL fails
Date: 2015-03-07 10:22:05
Message-ID: 54FAD14D.5010606@joops.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)7050902(at)gmx(dot)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_permissions_does_PostgreSQL_require.3F">http://wiki.postgresql.org/wiki/Running_%26_Installing_PostgreSQL_On_Native_Windows#What_filesystem_permissions_does_PostgreSQL_require.3F</a>
<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>

Attachment Content-Type Size
unknown_filename text/html 4.2 KB

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Josef Springer 2015-03-07 11:36:41 Re: Installing PostgreSQL fails
Previous Message John Scalia 2015-03-07 03:01:04 authenticating using Active Directory?