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-05 10:08:32
Message-ID: 54F82B20.4010906@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=UTF-8" http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#ffffff">
Hello Jan,<br>
<br>
the Server-Service  worked after reinstalling PostgreSQL correctly.<br>
But after copying back the backup of the folder <b>data</b>, the
Server-Service does not work anymore. <br>
What i did:<br>
<ul>
<li>Term the Server-Service</li>
<li>Copying back the backup of the folder <b>data</b></li>
<li>Starting the Server-Service (whitch did not)</li>
</ul>
So, i assume copying back the folder <b>data</b> is not enought.
Something is 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:
<blockquote cite="mid:54F32306(dot)5020609(at)gmx(dot)de" 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 privileges are wrong.
<br>
IIRC there's a batch file for setting the correct file privileges
( 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 Windows again!!!!
<br>
<br>
Good luck ...
<br>
<br>
<br>
<br>
<br>
</blockquote>
<br>
<div class="moz-signature"><br>
</div>
</body>
</html>

Attachment Content-Type Size
unknown_filename text/html 1.9 KB

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Josef Springer 2015-03-05 10:21:12 Re: Installing PostgreSQL fails
Previous Message Jim Nasby 2015-03-05 08:25:42 Re: Re: [pgadmin-support] Issue with a hanging apply process on the replica db after vacuum works on primary