| From: | "Tena Sakai" <tsakai(at)gallo(dot)ucsf(dot)edu> |
|---|---|
| To: | <pgsql-admin(at)postgresql(dot)org> |
| Subject: | my postgres is dead. need help! |
| Date: | 2007-07-27 16:31:00 |
| Message-ID: | FE44E0D7EAD2ED4BB2165071DB8E328C03062ACE@egcrc-ex01.egcrc.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hi folks,
My postgres (v 7.1.4, I think) did not come up upon reboot.
I have tried to use startup script called postgresql in
/etc/rc.d/init.d directory, but it reports FATAL when I
try to stop postmaster.
The most recent log file in /pgsql/data/pg_log reads:
LOG: database system was interrupted while in recovery at 2007-07-27 08:30:34 PDT
HINT: This probably means that some data is corrupted and you will have to use the last backup for recovery.
LOG: checkpoint record is at 1F8/DB354F24
LOG: redo record is at 1F8/D6060064; undo record is at 0/0; shutdown FALSE
LOG: next transaction ID: 700570822; next OID: 2763554
LOG: next MultiXactId: 3; next MultiXactOffset: 6
LOG: database system was not properly shut down; automatic recovery in progress
LOG: redo starts at 1F8/D6060064
FATAL: the database system is starting up
I am totally lost what I need to do.
Help and ssistance highly appreciated.
Regards,
Tena Sakai
tsakai(at)gallo(dot)ucsf(dot)edu
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chris Hoover | 2007-07-27 17:47:09 | Re: my postgres is dead. need help! |
| Previous Message | De Leeuw Guy | 2007-07-27 15:50:39 | trigger and pg_fini |