Thanks a lot for your message! That was a detailed explanation. On Sat, 22 Jan 2000, you wrote:
As far as I know Chapter 10 of the documentation, "Database Recovery" hasn't been written, unless you can find the topic in one of the several commercial books on PostGreSQL.
PostGreSQL is a serious database engine. It must be closed down in a gracious manner or, like any complex database structure, it will become corrupted. If you are running PostGreSQL to keep important data it is important, then, to protect that data by using an UPS (Universal Power Supply), which will give you time to perform a graceful shutdown in the when (NOT IF) the power fails.
I am a newbie, and as far as I know I am not keeping anything using PostGreSQL; but then, maybe some of my programs are? I assume something, somewhere in my machine must have been using it, because otherwise I would not be getting the error message at startup (and shutdown)? So far everyting seems to be working OK.... But given the error message, it seems related to something with mail (as postmaster seems involved0).. but again, I am a complete ignorant in this.
If the lock /tmp/.s.pgsql.5432 exists then delete it and try starting the engine again: /usr/bin/rcpostgrs start
You might try to start the engine with: echo "postmaster \B 256 >/var/log/pslog 2> &1 &" | su - postgres or nohup postmaster > logfile 2>&1 &
or one of the other commands given in chapter 3 of the documentation. If nothing works then check to see that your hostname has not changed. If it hasn't then restoring from a backup is the only thing left I can think of.
Nope, hostname is still the same; but given that I haven't (to my knowledge) kept anything important in that database, I guess I don't really need to restore from bakcup (to begin with, I don't know what files I'd need to restore).
Good luck, JLK
Thanks again, Ramon
>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
On 1/21/00, 1:14:40 AM, Ramon Diaz-Uriarte <rdiazuri@students.wisc.edu> wrote regarding [SLE] postgres error:
Hi,
A couple of days ago I had a power failure. I rebooted, the filesystems were checked, etc, and everything seems OK, except when booting and when shutting down I get these two messages:
Starting service postgresstartproc; exit status of /usr/pgsql/bin/postmaster:1 failed
and
Failed services in runlevel 3: postgres.
I've been looking around, but I still don't understand exactly what's happening. Is this serious? How can I fix it?
Thanks,
Ramon
-- To unsubscribe send e-mail to suse-linux-e-unsubscribe@suse.com For additional commands send e-mail to suse-linux-e-help@suse.com Also check the FAQ at http://www.suse.com/Support/Doku/FAQ/
-- To unsubscribe send e-mail to suse-linux-e-unsubscribe@suse.com For additional commands send e-mail to suse-linux-e-help@suse.com Also check the FAQ at http://www.suse.com/Support/Doku/FAQ/