X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id DF82F9FB1EE for ; Sun, 6 Aug 2006 11:47:15 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 98371-09 for ; Sun, 6 Aug 2006 14:47:13 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from web38109.mail.mud.yahoo.com (web38109.mail.mud.yahoo.com [209.191.124.136]) by postgresql.org (Postfix) with SMTP id C912F9FB1D3 for ; Sun, 6 Aug 2006 11:47:12 -0300 (ADT) Received: (qmail 68535 invoked by uid 60001); 6 Aug 2006 14:47:11 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=k2EfETCFYWZVgKFkT8WWmOEMHRAnsDI5ej9CpE2XnK6qPSFqkRwn66e7IYnBmcCPmGVcoEEHh/H9J9R4+Vkl6Wh8YPjswCozT9jlerjWuOy7FhoFoW0mXwXB9BqCpg7RMeXqTHQOUrx6Xay2CLQpAzowaukm5jRqxxmQ4Ao6OXo= ; Message-ID: <20060806144710.68533.qmail@web38109.mail.mud.yahoo.com> Received: from [71.248.73.101] by web38109.mail.mud.yahoo.com via HTTP; Sun, 06 Aug 2006 07:47:10 PDT Date: Sun, 6 Aug 2006 07:47:10 -0700 (PDT) From: Srinivas Iyyer Subject: pg_dump problem To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=3.355 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS X-Spam-Level: *** X-Archive-Number: 200608/54 X-Sequence-Number: 22598 Dear group, I have two databases in my system. In firstdb i am having the following problem: firstdb=# \d targets ERROR: could not access status of transaction 362 DETAIL: could not open file "/var/lib/pgsql/data/pg_clog/0000": No such file or directory when I vacuumed it: $ vacuumdb firstdb vacuumdb: vacuuming of database "firstdb" failed: ERROR: could not access status of transaction 11 DETAIL: could not open file "/var/lib/pgsql/data/pg_clog/0000": No such file or directory Second problem: Issue with secondb - arraydb $ vacuumdb arraydb VACUUM Suspecting there is something going on with postgres, I wanted to take a backup of the arraydb. here is what I am doing: $ sudo pg_dump arraydb > arraydb_bcup_Aug_05_2006.dump There is nothing in this. I created dumps long back and they are heavy. I restarted the postgre server /etc/init.d/postgres restart Despite this, I am having problems. $ ls -lh total 8.0K -rw-r--r-- 1 speri postgres 0 Aug 5 20:17 arradb_bcup_Aug_05_2006.out What is in the /var/lib/pgsql/data/pg_clog $ sudo ls -lh /var/lib/pgsql/data/pg_clog total 80K -rw------- 1 postgres postgres 72K Aug 5 20:12 0001 Logs: Surprisingly my logs is empty . Is this because I restarted the server. what could be the problem in the cases of first and second problems. looking forward to hear from experts eagerly. Thanks __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com