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.
So, is there any way or tool to automatically check the consistency status of PostgreSQL
database when server starts up (like
the DBCC in SQL server)?
Thanks for the
suggestion.
B.R.
Kevin
Chen
