X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 901F8D1E136 for ; Thu, 19 Feb 2004 14:30:18 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 75551-01 for ; Thu, 19 Feb 2004 10:30:17 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id F35FCD1DF7F for ; Thu, 19 Feb 2004 10:30:05 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i1JEUE73001733; Thu, 19 Feb 2004 09:30:14 -0500 (EST) To: Olivier Hubaut Cc: PgSQL Admin Subject: Re: ANALYZE crashes randomly In-reply-to: <40349522.8090401@scmbb.ulb.ac.be> References: <40349522.8090401@scmbb.ulb.ac.be> Comments: In-reply-to Olivier Hubaut message dated "Thu, 19 Feb 2004 11:51:14 +0100" Date: Thu, 19 Feb 2004 09:30:14 -0500 Message-ID: <1732.1077201014@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/280 X-Sequence-Number: 12454 Olivier Hubaut 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