Re: Rescue data after power off

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: tuanhoanganh <hatuan05(at)gmail(dot)com>
Cc: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Rescue data after power off
Date: 2010-07-19 14:45:16
Message-ID: 4C4464FC.2000604@postnewspapers.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 19/07/10 18:37, tuanhoanganh wrote:
> When I use pgadmin to view data of table dmvt, it have data. But when I
> "select * from dmvt" there is error on log
>
> 2010-07-19 17:32:17 ICTWARNING: invalid page header in block 207 of
> relation "dmvt"; zeroing out page
> 2010-07-19 17:32:35 ICTLOG: server process (PID 3480) was terminated by
> exception 0xC0000005

If that message is always the same, it's likely that there's a bug
somewhere in the PostgreSQL database backend's handling of damaged
database files.

This almost certainly has nothing to do with whatever damaged the data
in the first place. Fixing it is very unlikely to bring your data back.

Your database file is still damaged, and if this error wasn't happening
it'd probably just give you an error saying it can't read the relation
instead of terminating like that. Nonetheless, it'd be nice to know
where it is crashing.

Since you can make the crash happen reliably every time, please consider
following the instructions at:

http://wiki.postgresql.org/wiki/Getting_a_stack_trace_of_a_running_PostgreSQL_backend_on_Windows

to collect some debugging information that might help.

It is unlikely that fixing this problem will bring your data back, but
it might provide more information that could help.

Please also post your postgresql.conf .

--
Craig Ringer

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Nicolas Payart 2010-07-19 15:03:29 Re: Can not change log_min_duration_statement parameter on PG 8.2.4
Previous Message Craig Ringer 2010-07-19 14:36:42 Re: Rescue data after power off