Re: Data recovery! - Mailing list pgsql-general

From Tom Lane
Subject Re: Data recovery!
Date
Msg-id 20601.1074488427@sss.pgh.pa.us
Whole thread Raw
In response to Data recovery!  (avalon@dolphin-3.bg)
List pgsql-general
avalon@dolphin-3.bg writes:
> Hallo. This is the log. This is postgresql 7.4.0.
> The problem appeared after few hang-ups because of phisical memory
> problem. Is there any way to recover the data?

Well, since the WAL log is clearly corrupt, you might as well do
pg_resetxlog.  Don't have a lot of faith in the validity of your
database afterwards though --- I'd suggest a dump and reload plus
as much manual cross-checking as you can think of.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: UNICODE-encoded database does not accept umlaut-characters.
Next
From: Tom Lane
Date:
Subject: Re: when I create a table, postgresql creates a new type