From: Tony Nelson <tnelson@starpoint.com>
To: pgsql-admin@postgresql.org
Subject: Corrupted disk
Date: Fri, 18 Feb 2011 10:12:16 -0500
Message-ID: <2B07A451-9F67-4438-8802-B10F46FDAF2E@starpoint.com> (raw)
Good morning all,
This morning my server (ubuntu 10.04 LTS, pg 8.4 from apt) experienced a disk corruption which caused errors like this:
Feb 18 08:50:07 ihdb1 postgres[13317]: [2-1] user=postgres,db=instihire ERROR: invalid page header in block 10 of relation base/16384/8082305
I am ok, because I have a dump from last night, and wal since then.
As a test, I tried doing a dump like this from the broken server:
pg_dump -Fc mydb > busted.dump
I restored this dump on a test server, and all of the data looks ok, and my application is able to run the operation that was failing in production just fine.
My question is simple, is my dump good? Is it possible that pg_dump was able to correctly save the data that "select .. " and "update.. " couldn't.
Can I drop/create/restore from this dump? Or should I restore from last nights full and apply the WAL?
Thanks for any help.
Tony Nelson
Starpoint Solutions
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tnelson@starpoint.com
Subject: Re: Corrupted disk
In-Reply-To: <2B07A451-9F67-4438-8802-B10F46FDAF2E@starpoint.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox