Re: [GENERAL] Still big problems with pg_dump! - Mailing list pgsql-admin

From Wim
Subject Re: [GENERAL] Still big problems with pg_dump!
Date
Msg-id 3D874028.7020501@belbone.be
Whole thread Raw
In response to Re: [GENERAL] Still big problems with pg_dump!  (Andrew Sullivan <andrew@libertyrms.info>)
Responses Re: [GENERAL] Still big problems with pg_dump!
List pgsql-admin

Andrew Sullivan wrote:

<snip>...

>>>How did you check?
>>>
>>>
>>>
>>>
>>with fsck.
>>
>>
>
>That won't help you if the controller is coming and going; you might
>find that it works one time, and not another.  Indeed, a disk on its
>way out can even pass fsck sometimes, although it's pretty unusual.
>
The DB is located on a RAID5 disk array...

>
>
>>Have backup... I can still SQL COPY to a text file, so that's no problem
>>so far.
>>
>>
>
>Well, that's good.  I'd suggest backing up _really often_ until you
>know what the problem is, especially since this is production.
>
>
>
>>I know, I don't have much spare hardware, and the database had to work
>>quickly, it was the
>>only solution then.
>>Checked the disk, reinstalled the OS and still waiting for a CPU and
>>memory upgrade.
>>
>>
>
>Do you have another place to store the database in the meantime -- an
>Intel box with a cheap disk, or anything?  At least you'd have
>another copy of the database somewhere that way.
>
>A
>
>
>
Don't have a disk that can store my database...


Still searching....


Cheers!

Wim


pgsql-admin by date:

Previous
From: Wim
Date:
Subject: Re: [GENERAL] Copying table to another database.
Next
From: Andrew Sullivan
Date:
Subject: Re: [GENERAL] Still big problems with pg_dump!