Re: ERROR: _mdfd_getrelnfd: cannot open relation pg_temp_15300_53: No such file or directory
От | Andrew Bartley |
---|---|
Тема | Re: ERROR: _mdfd_getrelnfd: cannot open relation pg_temp_15300_53: No such file or directory |
Дата | |
Msg-id | 060b01c27957$d6180810$3200a8c0@abartleypc обсуждение исходный текст |
Ответ на | Looking for foreign key guinea pigs (Stephan Szabo <sszabo@megazone23.bigpanda.com>) |
Ответы |
Re: ERROR: _mdfd_getrelnfd: cannot open relation pg_temp_15300_53: No such file or directory
|
Список | pgsql-general |
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 > >
В списке pgsql-general по дате отправления: