Re: need help for PostgreSQL consistency check mechanism

I wanna know if there is any way or tool to detect the DB data loss or
damage and inform developer the result before recovery? If there is
data loss, the DB could still open or not ?
Sometimes even if shutdown abnormally, the data still keep in good
condition.

Thanks for your help!

B.R.

ChenDongdong

-----Original Message-----
From: Joshua D. Drake [mailto:jd(at)commandprompt(dot)com]
Sent: Friday, April 24, 2009 9:18 AM
To: Chen, Dongdong (GE Healthcare)
Cc: Alvaro Herrera; pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] 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