Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id B551DB5DBC0 for ; Thu, 16 Jun 2011 02:28:13 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 49679-05 for ; Thu, 16 Jun 2011 05:28:07 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from sam.nabble.com (sam.nabble.com [216.139.236.26]) by mail.postgresql.org (Postfix) with ESMTP id 7FB24B5DBF6 for ; Thu, 16 Jun 2011 02:28:07 -0300 (ADT) Received: from [192.168.236.26] (helo=sam.nabble.com) by sam.nabble.com with esmtp (Exim 4.72) (envelope-from ) id 1QX57e-0002R2-Sc for pgsql-admin@postgresql.org; Wed, 15 Jun 2011 22:28:06 -0700 Date: Wed, 15 Jun 2011 22:28:06 -0700 (PDT) From: bakkiya To: pgsql-admin@postgresql.org Message-ID: <1308202086880-4493683.post@n5.nabble.com> Subject: could not open temporary statistics file "pg_stat_tmp/pgstat.tmp" MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.766 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, RFC_ABUSE_POST=0.001, T_TO_NO_BRKTS_FREEMAIL=0.01, URI_HEX=1.122 X-Spam-Level: X-Archive-Number: 201106/87 X-Sequence-Number: 37713 Hi, We have postgresql9.0 in our Linux server. We are continously getting "could not open temporary statistics file "pg_stat_tmp/pgstat.tmp": No such file or directory" message in the db log file.We have data/pg_stat_tmp directory in, but pgstat.tmp file is not ppresent in this directory.Can someone tell us why this error messgae is logged? Thanks. -- View this message in context: http://postgresql.1045698.n5.nabble.com/could-not-open-temporary-statistics-file-pg-stat-tmp-pgstat-tmp-tp4493683p4493683.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com.