From: Dimitrios Apostolou <jimis@gmx.net>
To: Sergey Fukanchik <fukanchik@gmail.com>
Cc: pgsql-general@lists.postgresql.org
Subject: Re: Orphan files filling root partition after crash
Date: Wed, 28 Feb 2024 13:51:31 +0100 (CET)
Message-ID: <07f2e362-24a2-f382-decb-c90025ce2d87@gmx.net> (raw)
In-Reply-To: <CAB+D6kVyqpFSgkVeS87ttg7rZ8gg+nk71cCUVeK1LSM-fJV6qw@mail.gmail.com>
References: <d15a32be-915e-3cd8-4622-5a052d621f13@gmx.net>
<CAB+D6kVyqpFSgkVeS87ttg7rZ8gg+nk71cCUVeK1LSM-fJV6qw@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-general@postgresql.org
Cc: jimis@gmx.net, fukanchik@gmail.com, pgsql-general@lists.postgresql.org
Subject: Re: Orphan files filling root partition after crash
In-Reply-To: <07f2e362-24a2-f382-decb-c90025ce2d87@gmx.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox