Re: Postgresql + corrupted disk = data loss. (Need help for database recover) - Mailing list pgsql-general

From Craig Ringer
Subject Re: Postgresql + corrupted disk = data loss. (Need help for database recover)
Date
Msg-id 4ED9CE72.3060706@ringerc.id.au
Whole thread Raw
In response to Postgresql + corrupted disk = data loss. (Need help for database recover)  (Oleg Serov <serovov@gmail.com>)
List 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

pgsql-general by date:

Previous
From: Edson Richter
Date:
Subject: Re: PostgreSQL 9.0 and asynchronous replication through VPN
Next
From: Harald Fuchs
Date:
Subject: Re: Oddball data distribution giving me planner headaches