On Mon, 2021-04-26 at 16:45 -0400, Alvaro Herrera wrote:
> I would guess that there are leftover files because of those crashes you
> mentioned. You can probably look for files in the database subdir in
> the data directory that do not appear in the pg_class.relfilenode
> listing for the database.
Not all tables have their "relfilenode" set:
SELECT relfilenode FROM pg_class WHERE relname = 'pg_class';
relfilenode
═════════════
0
(1 row)
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com