pg_dump question

From: Srinivas Iyyer <srini_iyyer_bio(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: pg_dump question
Date: 2006-08-07 13:12:25
Message-ID: 20060807131225.33009.qmail@web38113.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Adam Fernie 2006-08-07 13:21:54 pg_hba.conf includes
Previous Message Chris Mair 2006-08-07 08:54:24 Re: Performance tuning question