Are there any tools available to dump datafiles for debugging purposes? I think there is a corruption problem in Postgresql 7.4.2 with and only with the Ltree module. 
I've seen broken ltree entries in my database, and there were no updates on the tables. This occurs once or twice a day, at random times. The value of the ltree
attribute is not junk as I would expect with a corruption, but some parts are missing.

I've wrote some sort of watchdog and waited until the problem occured, then copied the datafile to a different location.

Are there any tools available for debugging such problems? Even a simple dump to stdout would be helpful.

Thanks!

Regards,
	Mario Weilguni

p.s. I've checked the hardware before going online with that database, RAM is definitly ok, and the rest of the hardware should work fine as well. 
The table was vacuumed full, but vacuum did not report any errors.


Mon, 7 Jun 2004 21:51:12 +0200
Mario Weilguni <mweilguni@sime.com>
Tool to read data files
Mario Weilguni <mweilguni@sime.com> writes:
> Are there any tools available to dump datafiles for debugging
> purposes?

I often use pg_filedump, available here:
http://sources.redhat.com/rhdb/

> I think there is a corruption problem in Postgresql 7.4.2 with and
> only with the Ltree module.

Could be; I doubt anyone has tested ltree harder than running its
regression test for quite awhile.  It could be suffering bit rot
from some of the changes in 7.4 (or even an earlier release).

			regards, tom lane

Tue, 08 Jun 2004 00:45:30 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: Tool to read data files 