I wanna know if there is any way or tool to detect the DB data loss or damage and inform developer the result before recovery? If there is data loss, the DB could still open or not ? Sometimes even if shutdown abnormally, the data still keep in good condition. Thanks for your help! B.R. ChenDongdong -----Original Message----- From: Joshua D. Drake [mailto:jd@xxxxxxxxxxxxxxxxx] Sent: Friday, April 24, 2009 9:18 AM To: Chen, Dongdong (GE Healthcare) Cc: Alvaro Herrera; pgsql-general@xxxxxxxxxxxxxx Subject: Re: need help for PostgreSQL consistency check mechanism On Fri, 2009-04-24 at 09:03 +0800, Chen, Dongdong (GE Healthcare) wrote: > What is the mechanism about automatic recovery when startup? I read > the PostgreSQL document and didnt find anything about this. can you > specify that, pls? http://www.postgresql.org/docs/8.3/static/wal-intro.html Sincerely, Joshua D. Drake > Thank you so much! > > > B.R. > > ChenDongdong > > -----Original Message----- > From: Alvaro Herrera [mailto:alvherre@xxxxxxxxxxxxxxxxx] > Sent: Friday, April 24, 2009 8:22 AM > To: Chen, Dongdong (GE Healthcare) > Cc: pgsql-general@xxxxxxxxxxxxxx > Subject: Re: need help for PostgreSQL consistency check > mechanism > > Chen, Dongdong (GE Healthcare) wrote: > > We are now working on database check mechanism in our application. > > The > > > situation is when server shutdown abnormally, the postmaster.pid > > file still exists when reboot, But the PostgreSQL database itself > > may not be damaged. We just do not want to restore from backups when > > the database is still good even if server shutdown abnormally. If > > the PostgreSQL database records are damaged for sure when server > > reboots, then the restoration should be executed automatically. > > Just start it up. If there is recovery to execute, it'll be done > automatically. > > -- > Alvaro Herrera > http://www.CommandPrompt.com/ > PostgreSQL Replication, Consulting, Custom Development, 24x7 support > -- PostgreSQL - XMPP: jdrake@xxxxxxxxxxxxxxxxxxxxx Consulting, Development, Support, Training 503-667-4564 - http://www.commandprompt.com/ The PostgreSQL Company, serving since 1997 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
