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