Re: Unable to determine what has a particular OID - Mailing list pgsql-general

From Andy Dale
Subject Re: Unable to determine what has a particular OID
Date
Msg-id AANLkTincFvPgp4vJ1Ip0pIf7R4e78OiOJJSh4IOOK2PQ@mail.gmail.com
Whole thread Raw
In response to Re: Unable to determine what has a particular OID  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Unable to determine what has a particular OID  (Andy Dale <andy.dale@gmail.com>)
List pgsql-general
On 18 June 2010 16:37, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Andy Dale <andy.dale@gmail.com> writes:
> On 18 June 2010 16:06, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> You should be looking at pg_class.relfilenode, not OID.  See
>> http://www.postgresql.org/docs/8.3/static/storage.html

> Ok, but when I have dumped the pg_class table into a file like so:
> ...
> Grep-ing  for the correct oid/filenode (110660 in my case), nothing is
> returned.

Hm.  You're sure you're looking at pg_class in the right database?

If there really isn't a pg_class entry matching that relfilenode,
then the files are orphans and can be removed.  There are some scenarios
where orphan files can be left behind, but they generally involve
database crashes ... have you had any of those?

                       regards, tom lane

To the best of my knowledge we have not had any DB crashes as yet.  I am also replicating the DB using slony, could this be the cause of these weird orphans ? (it is neither of the sl_log_ tables)

pgsql-general by date:

Previous
From: Andy Dale
Date:
Subject: Re: Unable to determine what has a particular OID
Next
From: Vick Khera
Date:
Subject: Re: Excessive Deadlocks On Concurrent Inserts to Shared Parent Row