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
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 |