Re: Fwd: When are largobject records TOASTed into pg_toast_2613?

Thomas Boussekey <thomas(dot)boussekey(at)gmail(dot)com> writes:
> Le ven. 21 août 2020 à 15:10, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> a
> écrit :
>> The safest way would be to upgrade with pg_dumpall/psql.

> The `pg_dumpall` command will also copy the content and the existence of
> the `pg_toast_2613` table, isn't it?

No. pg_dumpall does not do anything with system catalogs per se.

> Moreover, it will generate a large downtime

Yeah. It's a tradeoff of safety versus downtime. If that toast table
is physically empty (I would not bet on it without checking), then you
could manually hack up pg_class to remove the toast table, but there's
a nontrivial risk of permanently hosing your database by messing that
up.

regards, tom lane