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? 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
