On Thu, 9 Oct 2003, Vivek Khera wrote: > >>>>> "SD" == Shridhar Daithankar <[EMAIL PROTECTED]> writes: > > SD> Do a shutdown -h on a live database machine with pg. It will > SD> gracefully shut itself down. > > > I think it is a timing issue. The PG has no way to notify the OS that > it has finished exiting, so if it takes a long time to exit, the OS > will ungracefully kill the DB process(es). Doesn't matter what DB (or > any other application) you're running, you *can* lose data this way.
While it is possible to lose a non-committed transaction, WAL prevents the database from becoming corrupted. Assuming proper fsyncing of your hard drives (i.e. SCSI, or IDE with write cache disabled) ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org