When the OS starts up, it wants to detect whether there is data loss in PostgreSQL from last shutdown, is there a method provided?
Thanks for your help! B.R. ChenDongdong -----Original Message----- From: Scott Marlowe [mailto:scott.marl...@gmail.com] Sent: Friday, April 24, 2009 10:29 AM To: Chen, Dongdong (GE Healthcare) Cc: j...@commandprompt.com; Alvaro Herrera; pgsql-general@postgresql.org Subject: Re: [GENERAL] need help for PostgreSQL consistency check mechanism On Thu, Apr 23, 2009 at 8:24 PM, Chen, Dongdong (GE Healthcare) <dongdongc...@ge.com> wrote: > 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. Assuming non broken hardware and a drive subsystem that doesn't lie about fsync, and that the dba hasn't turned off fsync, an abnormal shutdown should NEVER result in a corrupted database. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
