pg not starting after power failure - Mailing list pgsql-admin

From Jason Nugent
Subject pg not starting after power failure
Date
Msg-id Pine.SUN.3.91.980604110450.23607A-100000@chebucto.ns.ca
Whole thread Raw
List 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@chebucto.ns.ca                 "This is who we are."
jason@irt.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
********************************************************************


pgsql-admin by date:

Previous
From: Przemyslaw Bak
Date:
Subject: create and drop user
Next
From: jcc2@juno.com (John C Cusick)
Date:
Subject: Re: [ADMIN] pg not starting after power failure