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-14 13:27:20
Message-ID: 55043738.3000500@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=windows-1251"
http-equiv="Content-Type">
<title></title>
</head>
<body text="#000000" bgcolor="#ffffff">
Hello Peter,<br>
<br>
thanks for your hints ! Your information gave me the resolution. <br>
<i>pg_clt start</i> gave me the information about a corrupted
postmaster.pid (filesize was 1k, but empty).<br>
So i installed 8.2.1 and copied the folder data backup without
postmaster.pid.<br>
And what a suprise, all works perfectly and my databases are back.<br>
<br>
Thanks for your assistance,<br>
Josef Springer<br>
<br>
On 07.03.2015 17:38, Jan-Peter Seifert wrote:
<blockquote cite="mid:54FB299A(dot)9090501(at)gmx(dot)de" type="cite">Am
07.03.2015 um 11:22 schrieb Josef Springer:
<br>
<br>
<blockquote type="cite">yes, i used the same win-user for
installation and the same user
<br>
(default postgres) an password for the server-service.
<br>
<br>
  * Server works after reinstallation.
<br>
  * I terminate server-service
<br>
  * I restore backup of folder data
<br>
  * I start server-service
<br>
  * Starting of server-service is abandomed with errormessage
"Fehler
<br>
    1053 Der Dienst antwortet nicht auf die Start oder
Steueranweisung"
<br>
<br>
Any ideas ?
<br>
</blockquote>
<br>
Hello Josef,
<br>
<br>
try to start it from command line (as user postgres!):
<br>
<a class="moz-txt-link-freetext" href="http://www.postgresql.org/docs/8.2/static/app-pg-ctl.html">http://www.postgresql.org/docs/8.2/static/app-pg-ctl.html</a>
<br>
<br>
As soon as you can start up the server successfully stop it again
(in another command line window or by adding ' &amp;' (no quotes)
at the end of the command).
<br>
<br>
Then you can add a new service by using the pg_ctl option
register.
<br>
<br>
You can remove the old one by using 'sc delete':
<br>
<a class="moz-txt-link-freetext" href="https://technet.microsoft.com/de-de/library/cc742045(v=ws.10).aspx">https://technet.microsoft.com/de-de/library/cc742045(v=ws.10).aspx</a>
<br>
<br>
Good luck,
<br>
<br>
Peter
<br>
<br>
<br>
<br>
</blockquote>
<br>
<div class="moz-signature"><br>
</div>
</body>
</html>

Attachment Content-Type Size
unknown_filename text/html 2.6 KB

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Rossi, Maria 2015-03-16 00:38:53 Re: Errorlog empty
Previous Message jaime soler 2015-03-14 12:01:24 Re: WAL log management w/ multiple slaves