Re: [GENERAL] OID IS INVALID? - Mailing list pgsql-general

From Vadim Mikheev
Subject Re: [GENERAL] OID IS INVALID?
Date
Msg-id 379672E8.3AD9C147@krs.ru
Whole thread Raw
In response to OID IS INVALID?  (Mark Wilson <mwilson@sundog.larc.nasa.gov>)
List pgsql-general
Mark Wilson wrote:
>
> Last night I reformatted the disk, create a new filesystem and restored
> the last good full backup (from about a week ago) hoping I could get a
                ^^^^^^^^^^^
What did you use for backup ?
pg_dump/copy or you cp-ed datafiles to another place ?

> version of the system back on the disk prior to this event.  Unfortunately
> I'm still given the same exact errors shown above.  Does anyone have an
> idea of what I can to do fix these problems.  I really need to get the
> database back online quickly.

Either disk is still bad or you didn't use pg_dump/copy for backup.

Vadim

pgsql-general by date:

Previous
From: Leon
Date:
Subject: Re: [GENERAL] Re: [SQL] bad select performance fixed by forbidding hash joins
Next
From: "Hub.Org News Admin"
Date:
Subject: ...