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