Re: Postgresql + corrupted disk = data loss. (Need help for database recover)

From: Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>
To: Oleg Serov <serovov(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Postgresql + corrupted disk = data loss. (Need help for database recover)
Date: 2011-12-03 07:23:30
Message-ID: 4ED9CE72.3060706@ringerc.id.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 12/02/2011 09:08 AM, Oleg Serov wrote:
> Then i've analyzed log, and found this:
> 7 days ago appears this errors:
> db= LOG: could not rename temporary statistics file
> "pg_stat_tmp/pgstat.tmp" to "pg_stat_tmp/pgstat.stat":
> db= WARNING: pgstat wait timeout
> ERROR: missing chunk number 0 for toast value 2550017 in pg_toast_17076

Now that you've taken a file-level backup (hopefully copied to a
different computer), do you think it might be worth doing an fsck of the
file system? I'm wondering if your underlying storage has been doing
something dodgy.

--
Craig Ringer

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Harald Fuchs 2011-12-03 09:12:35 Re: Oddball data distribution giving me planner headaches
Previous Message Edson Richter 2011-12-03 03:01:33 Re: PostgreSQL 9.0 and asynchronous replication through VPN