Re: Rescue data after power off

[tuanhoanganh <hatuan05@xxxxxxxxx>]

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@xxxxxxxxx> wrote:

Yes, I don't have backup.

On Mon, Jul 19, 2010 at 4:24 PM, A. Kretschmer <andreas.kretschmer@xxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general