Re: need help for PostgreSQL consistency check mechanism

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@commandprompt.com]
Sent: Friday, April 24, 2009 8:22 AM
To: Chen, Dongdong (GE Healthcare)
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] 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