Re: Data recovery!

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: avalon(at)dolphin-3(dot)bg
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Data recovery!
Date: 2004-01-19 05:00:27
Message-ID: 20601.1074488427@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

avalon(at)dolphin-3(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-01-19 05:01:20 Re: when I create a table, postgresql creates a new type
Previous Message Tom Lane 2004-01-19 04:51:20 Re: UNICODE-encoded database does not accept umlaut-characters.