Re: [GENERAL] Problems restarting after database crashed (signal 11).

2004-07-08 Thread Christopher Cashell
At Sat, 03 Jul 04, Unidentified Flying Banana Greg Stark, said: > Is there an NFS server involved? If an NFS server disappears any process > waiting on I/O for it enters disk-wait indefinitely until it reappears. Nope. Everything was local on this machine. > -- > greg -- | Christopher +--

Re: [GENERAL] Problems restarting after database crashed (signal 11).

2004-07-03 Thread Greg Stark
Tom Lane <[EMAIL PROTECTED]> writes: > Christopher Cashell <[EMAIL PROTECTED]> writes: > > 28424 postgres 18 0 16804 3044 15m D 0.0 1.6 0:06.72 postmaster > > > Note that it does have a process status of 'D', or uninterruptible > > sleep. That would explain the unkillable part, though I'

Re: [GENERAL] Problems restarting after database crashed (signal 11).

2004-07-01 Thread Tom Lane
Christopher Cashell <[EMAIL PROTECTED]> writes: > [2004-06-30 08:44:53 AM] Failed connection to database template1 > with error: FATAL: the database system is starting up > . > [2004-06-30 08:44:53 AM] Failed connection to database template1 > with error: FATAL: the

Re: [GENERAL] Problems restarting after database crashed (signal 11).

2004-06-30 Thread Tom Lane
Christopher Cashell <[EMAIL PROTECTED]> writes: > 28424 postgres 18 0 16804 3044 15m D 0.0 1.6 0:06.72 postmaster > Note that it does have a process status of 'D', or uninterruptible > sleep. That would explain the unkillable part, though I'm curious how > it ended up there. Perhaps I'm

Re: [GENERAL] Problems restarting after database crashed (signal 11).

2004-06-30 Thread Christopher Cashell
At Wed, 30 Jun 04, Unidentified Flying Banana Tom Lane, said: > Christopher Cashell <[EMAIL PROTECTED]> writes: > > Eventually I attempted to shut it down and restart it, however that > > failed too. When I attempted to shut it down, I discovered a hung > > 'startup subprocess' that can't be kille

Re: [GENERAL] Problems restarting after database crashed (signal 11).

2004-06-30 Thread Tom Lane
Christopher Cashell <[EMAIL PROTECTED]> writes: > Eventually I attempted to shut it down and restart it, however that > failed too. When I attempted to shut it down, I discovered a hung > 'startup subprocess' that can't be killed. This is interesting because it seems just about exactly like this