Re: Data corruption zero a file - help!!

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Noel Faux <noel(dot)faux(at)med(dot)monash(dot)edu(dot)au>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Data corruption zero a file - help!!
Date: 2006-03-01 06:18:10
Message-ID: 20060301061810.GA17251@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-03-01 06:22:41 Re: Questions about large objects and the WAL
Previous Message Michael Fuhr 2006-03-01 05:54:48 Re: Data corruption zero a file - help!!