Re: Rescue data after power off - Mailing list pgsql-general

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.