Re: Orphan table files at data/base/

2024-02-28 Thread Riivo Kolka
. veebruar 2024 kell 16:30: > > On Wed, 2024-02-28 at 15:44 +0200, Riivo Kolka wrote: > > I was an unfortunate sequence of commands (all in single transaction) > > > > DROP TABLE huge; > > CREATE TABLE huge AS... (huge PostGIS ST_Union operation); > > CREATE INDEX ON hu

Orphan table files at data/base/

2024-02-28 Thread Riivo Kolka
I was an unfortunate sequence of commands (all in single transaction) DROP TABLE huge; CREATE TABLE huge AS... (huge PostGIS ST_Union operation); CREATE INDEX ON huge USING GIST (geometry); by a well-meaning user, that caused a crash+recovery: server process (PID 92411) was terminated by signal