Re: [ADMIN] Recovering corrupted data.

2000-03-24 Thread Thomas Dean
I just completed a lot of recovery from losing all the bin/* part of psql version 6.4.2, and had to install 6.5.3. The disk file format changed, so, I had to translate the disk files into sql commands.` Most of the tables I had were text, char, etc. So, I used the standatd unix tools, like stri

[ADMIN] Recovering corrupted data.

2000-03-24 Thread David Gilbert
I've got a database where psql claims the backend crashes for most queries I try to perform. There seems to be some subtle corruption somewhere. I'm wondering if anyone has done any work to try to recover data from postgres. Even something as simple as the datafile format would be a big step. I