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

From Tomas Vondra
Subject Re: Postgresql + corrupted disk = data loss. (Need help for database recover)
Date
Msg-id 4EDA2DD8.1000803@fuzzy.cz
Whole thread Raw
In response to Re: Postgresql + corrupted disk = data loss. (Need help for database recover)  (Oleg Serov <serovov@gmail.com>)
Responses Re: Postgresql + corrupted disk = data loss. (Need help for database recover)
List pgsql-general
On 2.12.2011 09:16, Oleg Serov wrote:
> Hello!
>
> i've don't try to do reindex. There was enough space.

Not sure whether you tried to reindex or not. And what do you mean by
'there was enough space'? For example with ext2 (and ext3/ext4) it was
rather simple to exhaust inodes long before the device was actually
full. What filesystem are you using, anyway?

This seems like a I/O issue, you should check the hardware and the
settings (e.g. what caches are enabled etc.). Post more details, if
possible. Have you checked S.M.A.R.T. info from the drives?

> And i have a full data-directory backup, when i've stop server, before
> start.

Good. Have you moved it to a different machine? Otherwise you don't have
a backup, just a copy.

Tomas

pgsql-general by date:

Previous
From: Christoph Zwerschke
Date:
Subject: Shared memory usage in PostgreSQL 9.1
Next
From: Tomas Vondra
Date:
Subject: Re: Shared memory usage in PostgreSQL 9.1