Postgres Pro
Downloads
Home   >   mailing lists

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

From Alvaro Herrera
Subject Re: need help for PostgreSQL consistency check mechanism
Date
Msg-id 20090424002209.GQ10358@alvh.no-ip.org
Whole thread Raw
In response to need help for PostgreSQL consistency check mechanism  ("Chen, Dongdong (GE Healthcare)" <DongdongChen@ge.com>)
Responses Re: need help for PostgreSQL consistency check mechanism  ("Chen, Dongdong (GE Healthcare)" <DongdongChen@ge.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

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