Re: Rescue data after power off

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
2010-07-19 17:32:35 ICTHINT: See C include file "ntstatus.h" for a
description of the hexadecimal value.
2010-07-19 17:32:35 ICTLOG: terminating any other active server processes
2010-07-19 17:32:35 ICTWARNING: terminating connection because of crash of
another server process
2010-07-19 17:32:35 ICTDETAIL: The postmaster has commanded this server
process to roll back the current transaction and exit, because another
server process exited abnormally and possibly corrupted shared memory.
2010-07-19 17:32:35 ICTHINT: In a moment you should be able to reconnect to
the database and repeat your command.
2010-07-19 17:32:35 ICTWARNING: terminating connection because of crash of
another server process
2010-07-19 17:32:35 ICTDETAIL: The postmaster has commanded this server
process to roll back the current transaction and exit, because another
server process exited abnormally and possibly corrupted shared memory.
2010-07-19 17:32:35 ICTHINT: In a moment you should be able to reconnect to
the database and repeat your command.
2010-07-19 17:32:36 ICTLOG: all server processes terminated; reinitializing
2010-07-19 17:32:46 ICTFATAL: pre-existing shared memory block is still in
use
2010-07-19 17:32:46 ICTHINT: Check if there are any old server processes
still running, and terminate them.

Is there anyway to fix it.

On Mon, Jul 19, 2010 at 5:00 PM, tuanhoanganh <hatuan05(at)gmail(dot)com> wrote:

> Yes, I don't have backup.
>
> On Mon, Jul 19, 2010 at 4:24 PM, A. Kretschmer <
> andreas(dot)kretschmer(at)schollglas(dot)com> wrote:
>
>> In response to tuanhoanganh :
>> > Is there anyway to rescue data afer power off.
>> > I have postgres database version 8.3.9 on windows 2003.
>> > Yesterday my server is power off, when i start server, some of table is
>> blank.
>> > Is there anyway to rescue it.
>>
>> Restore the data from your backup. You haven't a backup? Your problem.
>>
>>
>>
>> Regards, Andreas
>> --
>> Andreas Kretschmer
>> Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
>> GnuPG: 0x31720C99, 1006 CCB4 A326 1D42 6431 2EB0 389D 1DC2 3172 0C99
>>
>> --
>> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-general
>>
>
>