Re: page 1 of relation global/11787 was uninitialized

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