Re: Help using pgfsck

On Tue, Apr 15, 2003 at 03:34:03PM -0300, Vilson farias wrote:
> Mr. Oosterhout,
>
> it's been very hard to deal with this database error. Since my knowledge
> in perl is null I think it's easier to edit database files manually.
>
> Could you or someone here in pgsql-general tell me where can I find more
> information about database files and how to edit? Pgfsck gives me valuable
> information, but I don't know how to access and change pages it reports me.

Editing the database files directly doesn't seem to me to be a real good
idea. Unfortunatly I don't know as much about fixing the problems as I do
about finding them.

My guess is (and I would like an actual postgres developer to confirm this)
is that the numbers below give you the ctid of the tuples to delete. So,
executing (please have a backup of the entire data directory before
attempting this):

delete from cham_chamada where ctid = '(876,25)';
delete from cham_chamada where ctid = '(968,30)';
delete from cham_chamada where ctid = '(1862,31)';
^page ^tuple

*might* fix it. At least to the stage where pg_dump will work again.

Hope this helps,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> "the West won the world not by the superiority of its ideas or values or
> religion but rather by its superiority in applying organized violence.
> Westerners often forget this fact, non-Westerners never do."
> - Samuel P. Huntington