On Thu, 08 Dec 2011 09:02:15 +0800, Craig Ringer wrote:
> On 12/08/2011 08:20 AM, Walter Hurry wrote:
>> On Wed, 07 Dec 2011 22:20:30 +, jkells wrote:
>>
>>> I am relying on identifying and correcting a bad block.
>>
>> Well, good luck with that. Most of the time you can't. Just check your
>>
On 12/08/2011 07:41 AM, Kevin Grittner wrote:
That sounds like your storage system is failing, quite independently
from PostgreSQL. Copy the entire data directory tree to some other
medium immediately, and preserve this copy. If you hit bad blocks,
retry if possible.
If you find files you ca
On 12/08/2011 08:20 AM, Walter Hurry wrote:
On Wed, 07 Dec 2011 22:20:30 +, jkells wrote:
I am relying on identifying and correcting a bad block.
Well, good luck with that. Most of the time you can't. Just check your
disk, replace it if necessary, restore from your backup and roll forward
On Wed, 07 Dec 2011 22:20:30 +, jkells wrote:
> I am relying on identifying and correcting a bad block.
Well, good luck with that. Most of the time you can't. Just check your
disk, replace it if necessary, restore from your backup and roll forward.
Oh, you can't do that, since you didn't b
jkells wrote:
> I tried to do a cold backup/copy
> cp -r * ../data2/
>
> and received the following from cp
> cp: base/9221176/9221183: I/O error
That sounds like your storage system is failing, quite independently
from PostgreSQL. Copy the entire data directory tree to some other
medium i
On Wed, 07 Dec 2011 22:09:23 +, Walter Hurry wrote:
> On Wed, 07 Dec 2011 21:22:05 +, jkells wrote:
>
>> I do not have a recent backup of this database/table
>>
>> Any help would be appreciated.
>
> Here's some help: Next time you establish a database, set up and test
> the backup regime
On Wed, 07 Dec 2011 21:22:05 +, jkells wrote:
> I do not have a recent backup of this database/table
>
> Any help would be appreciated.
Here's some help: Next time you establish a database, set up and test the
backup regime.
We hear this tale of woe time and time again. I have *no* sympathy
It appears that I have a bad block/disk sector etc., which is preventing
me from retrieving the rows from this table. All other tables within
this database is fine.
In preparation for zeroing out the bad block I tried to do a cold backup/
copy
cp -r * ../data2/
and received the following fro
