Postgres Pro
Downloads
Home   >   mailing lists

Re: ANALYZE crashes randomly - Mailing list pgsql-admin

From Tom Lane
Subject Re: ANALYZE crashes randomly
Date
Msg-id 1732.1077201014@sss.pgh.pa.us
Whole thread Raw
In response to ANALYZE crashes randomly  (Olivier Hubaut <olivier@scmbb.ulb.ac.be>)
Responses Re: ANALYZE crashes randomly  (Olivier Hubaut <olivier@scmbb.ulb.ac.be>)
List pgsql-admin
Tree view 
Olivier Hubaut <olivier@scmbb.ulb.ac.be> writes:
> PANIC:  could not open transaction-commit log directory
> (/usr/local/pgsql/annot/pg_clog): Too many open files

Try reducing max_files_per_process (in postgresql.conf) and/or
increasing the kernel's limit on number of open files (I think
you set this via sysctl in /etc/rc, but it may vary depending on
OS X version).

            regards, tom lane

pgsql-admin by date:

Previous
From: "Lukasz Piskorz"
Date:
Subject: Help - postgresql 7.0 and cannot read block 7959 of pg_log
Next
From: Tom Lane
Date:
Subject: Re: Help - postgresql 7.0 and cannot read block 7959 of pg_log