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 <hatua...@gmail.com> wrote: > Yes, I don't have backup. > > On Mon, Jul 19, 2010 at 4:24 PM, A. Kretschmer < > andreas.kretsch...@schollglas.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@postgresql.org) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-general >> > >