Skip site navigation (1) Skip section navigation (2)

my postgres is dead. need help!

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 (view raw or flat)
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

Responses

pgsql-admin by date

Next:From: Chris HooverDate: 2007-07-27 17:47:09
Subject: Re: my postgres is dead. need help!
Previous:From: De Leeuw GuyDate: 2007-07-27 15:50:39
Subject: trigger and pg_fini

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group