pg not starting after power failure

From: Jason Nugent <ap958(at)chebucto(dot)ns(dot)ca>
To: pgsql-admin(at)postgresql(dot)org
Subject: pg not starting after power failure
Date: 1998-06-04 14:10:55
Message-ID: Pine.SUN.3.91.980604110450.23607A-100000@chebucto.ns.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hey folks,

Unfortunately, a lightning strike last evening caused a momentary
power flicker and my Redhat 4.2 Linux machine was bumped off line for a
minute or two. It was my "home" box that is only on about 10 minutes a
day and it didn't have a UPS, which is dumb. For some reason, postgres
no longer auto starts on boot anymore.
I had configured my /etc/inittab file to autostart it using

pg:2345:respawn:/bin/su - postgres -c "/usr/local/pgsql/bin/postmaster
-D/usr/local/pgsql/data >> /usr/local/pgsql/server.log 2>&1" /dev/null

One a single line. It does not start, and after about 10 tries
to respawn it stops because of a "respawn too fast" error. If I try to
start it using

nohup postmaster > server.log 2>&1 &

while logged into the postgres account, it also fails. Unfortunately, I
am not at home and don't have the actual error message, so I was
wondering if anyone else has had this problem with a forced shutdown. It
had been working beautifully for about two weeks now, with several
halt/restart sequences.
I would appreciate any insight.

Thanks to all,

Jason

---------------------
Jason Nugent, BSc(Hons)
ap958(at)chebucto(dot)ns(dot)ca "This is who we are."
jason(at)irt(dot)org
Certified Webmaster

Visit IRT.org - Internet Related Technologies - http://www.irt.org
Articles on all aspects of internet development, including -
CGI/Perl, CSS, JavaScript, dHTML, Java, XML, HTML

********************************************************************
The Best Place for Sport on the net! - Sportscience www.sportsci.org
********************************************************************

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message John C Cusick 1998-06-04 17:38:17 Re: [ADMIN] pg not starting after power failure
Previous Message Przemyslaw Bak 1998-06-04 10:49:20 create and drop user