Re: ERROR: _mdfd_getrelnfd: cannot open relation pg_temp_15300_53: No such file or directory

Thanks Tom,

I have already done this on our local site.

We have one remote site I do not have access to.

We are able to apply patches to this site only. Is there an automated way
of doing this.

I have tried to but together a shell script to touch these files. But it
seems that the table in question has a second pg_toast oid associated with
it.

How do I find this relation in the pg_ tables?

The version of postgres we are running is 7.2

Thanks

Andrew

----- Original Message -----
From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Andrew Bartley" <abartley(at)evolvosystems(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Sent: Tuesday, October 22, 2002 8:36 AM
Subject: Re: [GENERAL] ERROR: _mdfd_getrelnfd: cannot open relation
pg_temp_15300_53: No such file or directory

> "Andrew Bartley" <abartley(at)evolvosystems(dot)com> writes:
> > Is there someone who knows how to fix this?
> >
> > 2002-10-16 14:29:08 [18326] ERROR: _mdfd_getrelnfd: cannot open
> > relation
> > pg_temp_15300_53: No such file or directory
>
> Depending on which PG version you are running, you may be able to just
> drop that temp table. If that doesn't work, create a dummy file to
> match it, and then drop it. You need a command like
>
> touch $PGDATA/base/DBOID/FILENODE
>
> where DBOID is the OID of your database as seen in pg_database, and
> FILENODE is the pg_class.relfilenode value for the temp table.
>
> regards, tom lane
>
>