Re: need help for PostgreSQL consistency check mechanism

On Fri, 2009-04-24 at 09:03 +0800, Chen, Dongdong (GE Healthcare) wrote:
> 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?

http://www.postgresql.org/docs/8.3/static/wal-intro.html

Sincerely,

Joshua D. Drake

> Thank you so much!
>
>
> B.R.
>
> ChenDongdong
>
> -----Original Message-----
> From: Alvaro Herrera [mailto:alvherre(at)commandprompt(dot)com]
> Sent: Friday, April 24, 2009 8:22 AM
> To: Chen, Dongdong (GE Healthcare)
> Cc: pgsql-general(at)postgresql(dot)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
>
--
PostgreSQL - XMPP: jdrake(at)jabber(dot)postgresql(dot)org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997