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@sss.pgh.pa.us>
To: "Andrew Bartley" <abartley@evolvosystems.com>
Cc: <pgsql-general@postgresql.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@evolvosystems.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
>
>