Re: Rescue data after power off

From: Jayadevan M <Jayadevan(dot)Maymala(at)ibsplc(dot)com>
To: tuanhoanganh <hatuan05(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org, pgsql-general-owner(at)postgresql(dot)org
Subject: Re: Rescue data after power off
Date: 2010-07-19 11:02:31
Message-ID: OFBF825E17.38DABB08-ON65257765.003C218C-65257765.003CBE59@ibsplc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> Yesterday my server is power off, when i start server, some of table is
blank. Is there anyway to rescue it.
The "Power Off" - is it a planned/regular one? If yes, it makes sense to
have a normal shutdown of the database before the "Power Off".
You said "some of table is blank". If those tables just got populated
before the "Power Off" and the transactions were committed, PostgreSQL
might have used WALS and recovered.
Some information on what data was expected to be in those tables and how
they were populated , messages you got when you restarted PostgreSQL
server etc might give a better idea to those in forum who are in a
position to help.
Regards,
Jayadevan

From: tuanhoanganh <hatuan05(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Date: 07/19/2010 02:45 PM
Subject: [GENERAL] Rescue data after power off
Sent by: pgsql-general-owner(at)postgresql(dot)org

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.

Please help me. I am very confuse.
Tuan Hoang Anh

DISCLAIMER:

"The information in this e-mail and any attachment is intended only for
the person to whom it is addressed and may contain confidential and/or
privileged material. If you have received this e-mail in error, kindly
contact the sender and destroy all copies of the original communication.
IBS makes no warranty, express or implied, nor guarantees the accuracy,
adequacy or completeness of the information contained in this email or any
attachment and is not liable for any errors, defects, omissions, viruses
or for resultant loss or damage, if any, direct or indirect."

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Oleg Bartunov 2010-07-19 13:26:47 Re: Incorrect FTS result with GIN index
Previous Message tuanhoanganh 2010-07-19 10:37:15 Re: Rescue data after power off