From: Srinivas Iyyer <srini_iyyer_bio@yahoo.com>
To: pgsql-admin@postgresql.org
Subject: pg_dump problem
Date: Sun, 6 Aug 2006 07:47:10 -0700 (PDT)
Message-ID: <20060806144710.68533.qmail@web38109.mail.mud.yahoo.com> (raw)
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
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: srini_iyyer_bio@yahoo.com
Subject: Re: pg_dump problem
In-Reply-To: <20060806144710.68533.qmail@web38109.mail.mud.yahoo.com>
References: <20060806144710.68533.qmail@web38109.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