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

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