| From: | Steve Crawford <scrawford(at)pinpointresearch(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "pgsql-admin(at)postgresql(dot)org Admin" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: could not open relation with OID |
| Date: | 2011-07-13 23:51:28 |
| Message-ID: | 4E1E2F80.30709@pinpointresearch.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On 07/13/2011 04:32 PM, Tom Lane wrote:
> Steve Crawford<scrawford(at)pinpointresearch(dot)com> writes:
>> I've seen the "could not open relation with OID" error a couple times
>> recently ...
> Not worry....
> You might be able to dodge the problem by excluding temp relations from
> the reporting query, though whether the sum of only non-temp rel sizes
> is of value to you is hard to guess from here.
Data safety was my concern. The error is so rare that I can ignore it.
(The two I saw are the first in the 2+ years this server has been active
and were probably the result of running the report manually when the
database was active rather than the usual nighttime cron-run).
Cheers,
Steve
| From | Date | Subject | |
|---|---|---|---|
| Next Message | jenopob | 2011-07-14 01:45:08 | Re: How to auto switch the roles of master and standby |
| Previous Message | Tom Lane | 2011-07-13 23:32:21 | Re: could not open relation with OID |