Обсуждение: please help me
HELLO ,
This is pavankumar , working on postgresql 8.1.4, database, for which iam new and very less in knowledge. Iam not an expert.
please help me in resolving the problem which iam facing since one week.the problem is
1)IAM UNABLE TO TAKE A COMPLETE BACKUP OF DATABASE
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
3)IAM UNABLE TO RESOLVE THIS PROBLEM.
DATABASE: postgresql 8.1.4(also using pgadmin from remote system)
OPERATING SYSTEM: redhat enterprise linux 5 ON DELL POWER EDGE 2950
********database is stored on a gnbd .
THANKS IN ADVANCE
This is pavankumar , working on postgresql 8.1.4, database, for which iam new and very less in knowledge. Iam not an expert.
please help me in resolving the problem which iam facing since one week.the problem is
1)IAM UNABLE TO TAKE A COMPLETE BACKUP OF DATABASE
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
3)IAM UNABLE TO RESOLVE THIS PROBLEM.
DATABASE: postgresql 8.1.4(also using pgadmin from remote system)
OPERATING SYSTEM: redhat enterprise linux 5 ON DELL POWER EDGE 2950
********database is stored on a gnbd .
THANKS IN ADVANCE
pavankumar reddy <pavankumar.csn@gmail.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