Rebuild pg_toast from scratch? - Mailing list pgsql-general

From Moreno Andreo
Subject Rebuild pg_toast from scratch?
Date
Msg-id c0032b94-b519-187c-cb11-3a535df20b6b@evolu-s.it
Whole thread Raw
Responses Re: Rebuild pg_toast from scratch?
List pgsql-general
Hi,
     I have an issue with a Windows 10 PC with Postgres 9.1 x86.
Running some SELECTs we got "ERROR: could not open file 
"base/48121/784576": No such file or directory"

I then ran

select
n.nspname AS tableschema,
     c.relname AS tablename
from pg_class c
inner join pg_namespace n on (c.relnamespace = n.oid)
where c.relfilenode = 784576;

and discovered that the involved table is pg_toast_49713.

Now I need to recreate an empty copy of this table (data can be 
recovered later), how can I achieve this?

Thanks in advance
Moreno.-






pgsql-general by date:

Previous
From: Andreas Joseph Krogh
Date:
Subject: Re: Uninstall postgres
Next
From: Rob Sargent
Date:
Subject: Re: floating point output