[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    [GENERAL] postgres init script reports failure, but postmaster started
From:       IN Conny <in.conny () yahoo ! se>
Date:       2007-02-28 15:48:28
Message-ID: 73199.92842.qm () web23406 ! mail ! ird ! yahoo ! com
[Download RAW message or body]

Hi all,
I'm not sure if the following is a bug or not. The symptoms I have is pretty much \
like this bug https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=166117
which have been documented in various archives. However, I run postgres 8.1.

What I do is i try to restore from a backup. I have a base backup and some archived \
WALs which I restore from. 

If I, as a final step in the restoration, start up postgres with \
'/etc/init.d/postgresql-8.1 start' it will print [fail] to the shell and exit. This \
happens about halfway through the restoration of WAL archives. However, if I call \
'/etc/init.d/postgresql-8.1 status' it says that the status is online; the database \
is running. If I examine the logs it seems that the startup has continued running \
beyond the point where it stopped printing to shell. All WAL archives are restored. \
And the content of the database seems to be ok.

I also tried to use '/usr/lib/postgresql/8.1/bin/pg_ctl start' to start up the \
database instead of the /etc/init.d script. This works without any error messages.

Could I safely assume that the restoration was successful, although \
/etc/init.d/postgresql-8.1 says it failed?

Best,
I.N.

 		
---------------------------------

Stava rätt! Stava lätt! Yahoo! Mails stavkontroll tar hand om tryckfelen och mycket \
mer! Få den på http://se.mail.yahoo.com


[Attachment #3 (text/html)]

Hi all,<br>I'm not sure if the following is a bug or not. The symptoms I have is \
pretty much like this \
bug<br>https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=166117<br>which have been \
documented in various archives. However, I run postgres 8.1.<br><br>What I do is i \
try to restore from a backup. I have a base backup and some archived WALs which I \
restore from. <br><br>If I, as a final step in the restoration, start up postgres \
with '/etc/init.d/postgresql-8.1 start' it will print [fail] to the shell and exit. \
This happens about halfway through the restoration of WAL archives.<br>However, if I \
call '/etc/init.d/postgresql-8.1 status' it says that the status is online; the \
database is running. If I examine the logs it seems that the startup has continued \
running beyond the point where it stopped printing to shell. All WAL archives are \
restored. And the content of the database seems to be ok.<br><br>I also tried to use \
'/usr/lib/postgresql/8.1/bin/pg_ctl start' to start  up the database instead of the \
/etc/init.d script. This works without any error messages.<br><br>Could I safely \
assume that the restoration was successful, although /etc/init.d/postgresql-8.1 says \
it failed?<br><br>Best,<br>I.N.<br><p>&#32;  <hr size=1><br><table><tr><td>Stava \
rätt! Stava lätt! Yahoo! Mails stavkontroll tar hand om tryckfelen och mycket mer! Få \
den på <a href="http://se.mail.yahoo.com">http://se.mail.yahoo.com</a></td></tr></table>




[prev in list] [next in list] [prev in thread] [next in thread]