> 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@xxxxxxxxx> To: pgsql-general@xxxxxxxxxxxxxx Date: 07/19/2010 02:45 PM Subject: Rescue data after power off Sent by: pgsql-general-owner@xxxxxxxxxxxxxx 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." -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
