Re: Rebuild pg_toast from scratch? - Mailing list pgsql-general

From Tom Lane
Subject Re: Rebuild pg_toast from scratch?
Date
Msg-id 5458.1567691631@sss.pgh.pa.us
Whole thread Raw
In response to Rebuild pg_toast from scratch?  (Moreno Andreo <moreno.andreo@evolu-s.it>)
Responses Re: Rebuild pg_toast from scratch?
List pgsql-general
Moreno Andreo <moreno.andreo@evolu-s.it> writes:
>      I have an issue with a Windows 10 PC with Postgres 9.1 x86.

You realize 9.1 is long out of support ...

> Running some SELECTs we got "ERROR: could not open file 
> "base/48121/784576": No such file or directory"

Ugh :-(

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

TRUNCATE ought to be enough.

            regards, tom lane



pgsql-general by date:

Previous
From: Rob Sargent
Date:
Subject: Re: floating point output
Next
From: Lele Gaifax
Date:
Subject: Cannot restore dump when using IS DISTINCT FROM on a HSTORE column