Re: my postgres is dead. need help! - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: my postgres is dead. need help!
Date
Msg-id dcc563d10707271816y4c7e6a72o1bfcc8982664ea7f@mail.gmail.com
Whole thread Raw
In response to my postgres is dead. need help!  ("Tena Sakai" <tsakai@gallo.ucsf.edu>)
List pgsql-admin
On 7/27/07, Tena Sakai <tsakai@gallo.ucsf.edu> wrote:

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

PostgreSQL versions that old WILL EAT YOUR DATA.

Not if, just when.  If it comes back up, get a good backup and start
planning your migration to something newer, prefereably 8.2.4

>  LOG:  redo starts at 1F8/D6060064
>  FATAL:  the database system is starting up

This is normal.  Let it finish recovery.  If it logs something more
fatal messages saying it couldn't startup, then it's time to restore
from backups.

P.s. How old is the system you're running this on?  I'm guessing from
around the RedHat 5 era?

pgsql-admin by date:

Previous
From: "Tena Sakai"
Date:
Subject: documentation question
Next
From: "Tena Sakai"
Date:
Subject: Re: my postgres is dead. need help!