Re: Rebuild pg_toast from scratch?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Moreno Andreo <moreno(dot)andreo(at)evolu-s(dot)it>
Cc: PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org>
Subject: Re: Rebuild pg_toast from scratch?
Date: 2019-09-05 13:53:51
Message-ID: 5458.1567691631@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Moreno Andreo <moreno(dot)andreo(at)evolu-s(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lele Gaifax 2019-09-05 14:16:19 Cannot restore dump when using IS DISTINCT FROM on a HSTORE column
Previous Message Rob Sargent 2019-09-05 13:32:00 Re: floating point output