Re: Help using pgfsck

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
Subject: Re: Help using pgfsck
Date: 2003-04-14 23:52:10
Message-ID: 20030414235210.GA11934@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Apr 14, 2003 at 06:34:33PM -0300, Vilson farias wrote:
> Greetings,
>
> I've been trying to use pgfsck since my PostgreSQL database was raising a
> "Memory exhausted in
> AllocSetAlloc" but it seems pgfsck is reading my datetimes in a wrong way,
> so I can't export data to recover my database.

Yeah, sorry about that. I couldn't work out how datetimes and timestamps
were stored in the file so I never got round to adding them. As you can see
they look about 5 bytes in width. If you can work it out there is a section
near the front of the program that does the data type conversions. Add it
there and it should dump properly.
--
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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-04-14 23:54:27 Re: Are we losing momentum?
Previous Message Dennis Gearon 2003-04-14 23:41:28 Re: Are we losing momentum?