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:alvhe...@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: jdr...@jabber.postgresql.org Consulting, Development, Support, Training 503-667-4564 - http://www.commandprompt.com/ The PostgreSQL Company, serving since 1997 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
