| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | "Chen, Dongdong (GE Healthcare)" <DongdongChen(at)ge(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: need help for PostgreSQL consistency check mechanism |
| Date: | 2009-04-24 00:22:09 |
| Message-ID: | 20090424002209.GQ10358@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chen, Dongdong (GE Healthcare) | 2009-04-24 01:03:32 | Re: need help for PostgreSQL consistency check mechanism |
| Previous Message | Conrad Lender | 2009-04-23 23:12:26 | Re: standard_conforming_strings and pg_escape_string() |