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