Dave Steinberg <dave-pgsql@xxxxxxxxxxxxx> writes: > My biggest problem is the lack of any real error message on the server. > I don't see anything wrong in the system logs, and there's no core > file in the /var/postgresql directory. Are you sure core files are enabled; i.e. the server is running with 'ulimit -c unlimited' ? > I did a 'vacuumdb -afz' just as > a shot in the dark, without affect. Pretty much all I see in the logs > is this: > > <USER%DB x.y.z.a(51478) 487>LOG: unexpected EOF on client connection This means a client is dying or closing its connection prematurely, and would seem to be a different problem. It shouldn't ever cause the server to crash. > Googling turned up a few reports suggesting bad hardware, or corrupted > indexes, but I don't think that's the case here. > > Any starting points or ideas would be greatly appreciated. Make sure the server is able to dump a core file, and perhaps crank up the logging level. -Doug
