Postgres Pro
Downloads
Home   >   mailing lists

Re: ERROR: could not open relation with OID - Mailing list pgsql-general

From Andomar
Subject Re: ERROR: could not open relation with OID
Date
Msg-id 5537FE17.8040309@aule.net
Whole thread Raw
In response to ERROR: could not open relation with OID  (Steve Crawford <scrawford@pinpointresearch.com>)
List pgsql-general
Tree view 
> This morning we got the following error from a daily script that
> produces a simple largest-table report:
> ERROR: could not open relation with OID 597597503
>
 From a bit of Googling, it seems that Postgres was unable to open the
physical file that contains the relation.

Is it possible that there was an error accessing the disk?  How is the
filesystem that contains your PGDATA directory mounted?

Kind regards,
Andomar

pgsql-general by date:

Previous
From: Steve Crawford
Date:
Subject: ERROR: could not open relation with OID
Next
From: Jeff Ferguson
Date:
Subject: Streaming-SQL Database PipelineDB (Based on PostgreSQL 9.4) - Available in Beta