Re: Help using pgfsck

Greetings,

I found a way to fix this kind of database corruption. It seems only
invalid tuples cause database shutdown. I just did a lot of selects until I
found all of these tuples(just 1 in this case). After deletion of invalid
records my database is running again :).

Just in case, I'm dumping/restoring the entire database to make sure new
one doesn't has any problems.

I would like to thanks people that helped me, especially Mr. Oosterhout
who gave me a lot of valuable information.

Mr. Alex B, datetime type really existis (at least here in my PostgreSQL
7.1.2). Maybe it's an alias for timestamp type, but I'm not sure.

Best regards.

----- Original Message -----
From: "Martijn van Oosterhout" <kleptog(at)svana(dot)org>
To: "Vilson farias" <vilson(dot)farias(at)digitro(dot)com(dot)br>
Cc: <pgsql-general(at)postgresql(dot)org>; <ricardo(dot)klava(at)digitro(dot)com(dot)br>
Sent: Tuesday, April 15, 2003 8:20 PM
Subject: Re: [GENERAL] Help using pgfsck