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 D4C259FB257 for ; Mon, 7 Aug 2006 10:12:34 -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 55569-09 for ; Mon, 7 Aug 2006 13:12:27 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from web38113.mail.mud.yahoo.com (web38113.mail.mud.yahoo.com [209.191.124.140]) by postgresql.org (Postfix) with SMTP id 2C39E9FB20F for ; Mon, 7 Aug 2006 10:12:27 -0300 (ADT) Received: (qmail 33011 invoked by uid 60001); 7 Aug 2006 13:12:25 -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=GhFp4HTKh35davffjhB61Pc1vENBC6QsknovAq4UFH6YsnDWaskD52TCnmGTehzfksCEkjDzTT8rLUQJLuZtxH0+OcjTgV6oET/nF97j5SbXqi56X9MJEml1/VePFDlKnZRCdKEet0wJyRh802njbSOLeYpV57/axikscVlkLGY= ; Message-ID: <20060807131225.33009.qmail@web38113.mail.mud.yahoo.com> Received: from [72.85.25.196] by web38113.mail.mud.yahoo.com via HTTP; Mon, 07 Aug 2006 06:12:25 PDT Date: Mon, 7 Aug 2006 06:12:25 -0700 (PDT) From: Srinivas Iyyer Subject: pg_dump question 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/70 X-Sequence-Number: 22614 *** Apologies for re-posting this e-mail **** Dear group, I have a strange problem. apologies if this is the wrong place, however as a first option i am posting here. I have to subscribe to other special mailing lists. 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 $ ls -lh total 8.0K -rw-r--r-- 1 speri postgres 0 Aug 5 20:17 arradb_bcup_Aug_05_2006.out There is nothing in this. I created dumps long back and they are heavy. 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