Re: another pg database corruption?

On Tue, Oct 28, 2003 at 03:12:37PM +0100, pginfo wrote:
> >
>
> I do not have made any patchin on my kernel.I used the standart reiserfs
> with my linux distro.

Yes, but have you kept up to date with new kernel releases from Red
Hat? They're pretty good about releasing patched kernels if there is
a problem.

> > your disk. Note that to produce useful results, you may have to do
> > the destructive tests. You'll be wanting to back up your data first.
>
> I can not:). If I try pg_dump the pg crashes.One of my problems is to
> restore this data if possible.

Shut down the database, I'm afraid, and copy the data directory
before you start doing things.

> >From this position I spoke, that I need to be sure that pg is very stable.

So far as I've heard, the cases of clog file corruption have all been
related to hardware. You'd best think about replacing your disk or
your controller. Have you had any crashes lately? Anything unusual?
Are you using ECC RAM? (If not, are you sure you don't have bad RAM?
If you got a bad bit written at the wrong time, you'd have a real
mess.)

> Any idea for fixing this data is wellcome. I will check the data
> inconsistent.

As I understand it, you need to zero out the file with dummy data in
order to get going again. You really need to plough the archives for
what to do, though. I've never had to do this.

A

--
----
Andrew Sullivan 204-4141 Yonge Street
Afilias Canada Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110