Skip site navigation (1) Skip section navigation (2)

Re: please help me

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "pavankumar reddy" <pavankumar(dot)csn(at)gmail(dot)com>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: please help me
Date: 2010-08-27 16:27:46
Message-ID: 4C77A1320200002500034D2E@gw.wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-admin
pavankumar reddy <pavankumar(dot)csn(at)gmail(dot)com> wrote:
 
> working on postgresql 8.1.4
 
You need to at least get onto an 8.1 revision which is more recent. 
You're missing over four years of bug fixes.
 
http://www.postgresql.org/support/versioning
 
http://www.postgresql.org/docs/8.1/static/release.html
 
> 1)IAM UNABLE TO TAKE A COMPLETE BACKUP OF DATABASE
 
How are you attempting to make the backup?  What happens when you
try?
 
> 2)IAM UNABLE TO QUERY THE FULL DATA IN A PARTICULAR TABLE(where
> the database backup is stoping) giving an error like missing chunk
> number 0 for toast value  XXXXXX
 
Copy and paste is better than paraphrasing.
 
Please use capital letters more sparingly, and please read this
before your next post:
 
http://wiki.postgresql.org/wiki/Guide_to_reporting_problems
 
It should help guide you to posting the information people need in
order to be more helpful.
 
>From what you've posted so far, it appears that you have a database
corruption, so I feel safe in saying that your next step should be
to stop the database service and copy the entire data directory
tree.  Save this until you've been running without problems for a
few weeks or months.
 
-Kevin

In response to

pgsql-admin by date

Next:From: Ɓukasz BrodziakDate: 2010-08-27 16:48:16
Subject: Re: Tuple changes from relfilenodes
Previous:From: Richard SicklerDate: 2010-08-27 16:18:09
Subject: Re: running in a virtual environment

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group