Thomas Boussekey <thomas.boussekey@xxxxxxxxx> writes: > Le ven. 21 août 2020 à 15:10, Laurenz Albe <laurenz.albe@xxxxxxxxxxx> 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
