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



view thread (18+ messages)  latest in thread

Message-ID: <20060806144710.68533.qmail@web38109.mail.mud.yahoo.com>
Permalink:  ../20060806144710.68533.qmail@web38109.mail.mud.yahoo.com/
Also on:    postgresql.org/message-id/20060806144710.68533.qmail@web38109.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 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