Re: fsync=off & shutdown => crash? - Mailing list pgsql-general

From Tom Lane
Subject Re: fsync=off & shutdown => crash?
Date
Msg-id 1733.1202598207@sss.pgh.pa.us
Whole thread Raw
In response to fsync=off & shutdown => crash?  (Benjamin Arai <me@benjaminarai.com>)
List pgsql-general
Benjamin Arai <me@benjaminarai.com> writes:
> I was reading the docuementation for 8.3
> (http://www.postgresql.org/docs/8.3/static/wal-async-commit.html) and it
> states "An immediate-mode shutdown is equivalent to a server crash, and
> will therefore cause loss of any unflushed asynchronous commits.". Does
> this mean that doing a "shutdown" (centos: /sbin/service postgresql
> stop) will be considered a crash?

Not unless the initscript uses an immediate-mode shutdown signal,
which would be a fairly unfriendly thing for it to do.

            regards, tom lane

pgsql-general by date:

Previous
From: Benjamin Arai
Date:
Subject: fsync=off & shutdown => crash?
Next
From: rihad
Date:
Subject: help optimizing query