Re: need help for PostgreSQL consistency check mechanism - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: need help for PostgreSQL consistency check mechanism
Date
Msg-id 1240535902.7028.1.camel@jd-laptop.pragmaticzealot.org
Whole thread Raw
In response to Re: need help for PostgreSQL consistency check mechanism  ("Chen, Dongdong (GE Healthcare)" <DongdongChen@ge.com>)
Responses Re: need help for PostgreSQL consistency check mechanism
List pgsql-general
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@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
>
--
PostgreSQL - XMPP: jdrake@jabber.postgresql.org
   Consulting, Development, Support, Training
   503-667-4564 - http://www.commandprompt.com/
   The PostgreSQL Company, serving since 1997


pgsql-general by date:

Previous
From: "Chen, Dongdong (GE Healthcare)"
Date:
Subject: Re: need help for PostgreSQL consistency check mechanism
Next
From: "Joshua D. Drake"
Date:
Subject: Re: standard_conforming_strings and pg_escape_string()