| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| To: | "Stephen R(dot) van den Berg" <srb(at)cuci(dot)nl> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: page 1 of relation global/11787 was uninitialized |
| Date: | 2013-04-09 16:27:52 |
| Message-ID: | 51644188.4040903@commandprompt.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2013-04-09 16:28:03 | Re: [COMMITTERS] pgsql: Add sql_drop event for event triggers |
| Previous Message | Dimitri Fontaine | 2013-04-09 16:27:13 | Re: Call for Google Summer of Code mentors, admins |