postgres init script reports failure, but postmaster started

From: IN Conny <in(dot)conny(at)yahoo(dot)se>
To: pgsql-general(at)postgresql(dot)org
Subject: postgres init script reports failure, but postmaster started
Date: 2007-02-28 15:48:28
Message-ID: 73199.92842.qm@web23406.mail.ird.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-02-28 15:55:06 Re: Post-Reboot Issue: Postmaster Not Accessible
Previous Message Joshua D. Drake 2007-02-28 15:30:27 Re: Post-Reboot Issue: Postmaster Not Accessible