Re: FATAL 2: open of /var/lib/pgsql/data/pg_clog/0EE3

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Dmitry Tkach <dmitry(at)openratings(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: FATAL 2: open of /var/lib/pgsql/data/pg_clog/0EE3
Date: 2003-07-18 16:33:41
Message-ID: Pine.LNX.4.33.0307181033040.2290-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, 18 Jul 2003, Dmitry Tkach wrote:

> scott.marlowe wrote:
>
> >
> >did you dump and reload your database?
> >
> Nope... It's a 200 Gig database.... If it was that simple to dump and
> reload it, I would have upgraded to 7.3, not 7.2.4 to begin with :-(
>
> >It may well be that 7.2.1 planted
> >logic bombs in the base directory that 7.2.4 can't fix now. I.e. some
> >data structure got munged and now 7.2.4 is busy complaining about it.
> >
> Why doesn't it complain after I restart it then?

Why should it? If the problem is corrupted data in an index / table
/system table etc... you won't see an error until it accesses the
table/index etc... that's causing the problem.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message nolan 2003-07-18 16:40:28 Re: Scheduled back up (fwd)
Previous Message Dmitry Tkach 2003-07-18 16:24:58 Re: FATAL 2: open of /var/lib/pgsql/data/pg_clog/0EE3