ANALYZE crashes randomly - Mailing list pgsql-admin

From Olivier Hubaut
Subject ANALYZE crashes randomly
Date
Msg-id 40349522.8090401@scmbb.ulb.ac.be
Whole thread Raw
Responses Re: ANALYZE crashes randomly  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Hi,

On PostgreSQL 7.3.3 on MacOS X 10.2, the ANALYZE command sometimes crash
and I don't know why! I've tried it some binaries copies of the DB, it's
a totally random behaviour.

When it crahes, I get this message:

PANIC:  could not open transaction-commit log directory
(/usr/local/pgsql/annot/pg_clog): Too many open files
server closed the connection unexpectedly
         This probably means the server terminated abnormally
         before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.

Does anyone know how to resolve it?

--
Signature en cours de maintenance,
Veuillez patienter...

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Knowing postgres processes..
Next
From: "Guy Smith"
Date:
Subject: Concerned about previous version still in place