pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Srinivas Iyyer <srini_iyyer_bio@yahoo.com>
To: pgsql-admin@postgresql.org
Subject: pg_dump question
Date: Mon, 7 Aug 2006 06:12:25 -0700 (PDT)
Message-ID: <20060807131225.33009.qmail@web38113.mail.mud.yahoo.com> (raw)

*** 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 



view thread (10+ messages)  latest in thread

Message-ID: <20060807131225.33009.qmail@web38113.mail.mud.yahoo.com>
Permalink:  ../20060807131225.33009.qmail@web38113.mail.mud.yahoo.com/
Also on:    postgresql.org/message-id/20060807131225.33009.qmail@web38113.mail.mud.yahoo.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: srini_iyyer_bio@yahoo.com
  Subject: Re: pg_dump question
  In-Reply-To: <20060807131225.33009.qmail@web38113.mail.mud.yahoo.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox