Re: Orphan files filling root partition after crash

Hi Sergey,

On Wed, 28 Feb 2024, Sergey Fukanchik wrote:

> Hi Dimitrios,
> Do you have wal archiving enabled?
> $PGDATA/pg_wal/ is a bit different from tablespaces (including
> "default" one). It stores transaction journal.

I don't think I have WAL archiving enabled. Here are the relevant WAL
options in my config:

wal_compression = zstd
max_wal_size = 8GB
min_wal_size = 1GB
track_wal_io_timing = on
wal_writer_flush_after = 8MB

The issue happens because the WAL directory is by default in the same
filesystem with the default tablespace (root partition for Ubuntu). So
when the default tablespace filled up because of my ALTER TABLE operation,
there was no space for WAL either.

Thanks,
Dimitris