On 04/09/2013 09:21 AM, Stephen R. van den Berg wrote:
> -------------------------
>
> Looking at global/11787, doesn't reveal any obvious corruption.
> The server was running with:
> synchronous_commit = off
> full_page_writes = off
full_page_writes = off is the problem.
From the docs:
Turning this parameter off speeds normal operation, but might lead to
either unrecoverable data corruption, or silent data corruption, after a
system failure. The risks are similar to turning off fsync, though
smaller, and it should be turned off only based on the same
circumstances recommended for that parameter.
http://www.postgresql.org/docs/9.0/static/runtime-config-wal.html#GUC-FULL-PAGE-WRITES
Sincerely,
Joshua D. Drake
--
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support, Training, Professional Services and Development
High Availability, Oracle Conversion, Postgres-XC
@cmdpromptinc - 509-416-6579
