Postgres Pro
Downloads
Home   >   mailing lists

Re: Data corruption zero a file - help!! - Mailing list pgsql-general

From Michael Fuhr
Subject Re: Data corruption zero a file - help!!
Date
Msg-id 20060301061810.GA17251@winnie.fuhr.org
Whole thread Raw
In response to Re: Data corruption zero a file - help!!  (Michael Fuhr <mike@fuhr.org>)
List pgsql-general
Tree view 
On Tue, Feb 28, 2006 at 10:54:48PM -0700, Michael Fuhr wrote:
> Is your table really over 100G?  Anyway, if the block size is 8192
> then 902292 sould be in the .6 file.  If you can spare the time
> then you might run the dd and od commands that Tom Lane mentions
> in the above message and post the output.

pg_filedump is also handy for examining the backend's data files.

http://sources.redhat.com/rhdb/utilities.html

--
Michael Fuhr

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Data corruption zero a file - help!!
Next
From: Tom Lane
Date:
Subject: Re: Questions about large objects and the WAL