Search Postgresql Archives

Re: 7.3.2 closing connections, sometimes

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



felix@xxxxxxxxxxx wrote:
> > Bruce Momjian <pgman@xxxxxxxxxxxxxxxx> writes:
> > > This message is from the backend exiting abruptly.  Is isn't an "ERROR"
> > > as we define it for logging purposes.  That's why there is nothing in
> > > the logs.
> > 
> > Nonetheless I'd expect there to be at least a postmaster complaint about
> > a crashed backend --- assuming that that's what's going on.  Do the
> > other active connections get forcibly closed when this happens?
> 
> Haven't had any others open, it's a dev system.  But I'll try leaving
> a psql session open.  Right now it's gotten itself into the mood of
> always working, so it might have to wait a while.
> 
> Could a corrupt db cause these mood swings?  And if so, would that
> persist even across dropdb / creatdb?

Yes, that is possible, but usually it would fail consistently.  Have you
run memtest and disk diagnostics?

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@xxxxxxxxxxxxxxxx               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux