Hosting Provided By

Re: [ADMIN] my postgres is dead. need help!

From: Scott Marlowe <scott.marlowe(at)gmail.com>
Date: Fri Jul 27 2007 - 21:16:06 EDT

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?

---------------------------(end of broadcast)---------------------------

TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq Received on Fri Jul 27 21:24:41 2007

Do you need help?

This message: [ Message body ]
Next message: Tena Sakai: "Re: [ADMIN] my postgres is dead. need help!"
Previous message: Tena Sakai: "[ADMIN] documentation question"
In reply to: Tena Sakai: "[ADMIN] my postgres is dead. need help!"
Next in thread: Tena Sakai: "Re: [ADMIN] my postgres is dead. need help!"
Reply: Tena Sakai: "Re: [ADMIN] my postgres is dead. need help!"

Contemporary messages sorted: [ By Date ] [ By Thread ] [ By Subject ] [ By Author ] [ By messages with attachments ]

This archive was generated by hypermail 2.1.8 : Thu Aug 09 2007 - 19:44:43 EDT