From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: marle.saransig@gmail.com
Subject: BUG #18821: Need delete files in pg_wal, size is bigger overcome limit max_wal_size
Date: Thu, 20 Feb 2025 17:42:40 +0000
Message-ID: <18821-fd87033e4102cf03@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 18821
Logged by: Marlene Saransig
Email address: marle.saransig@gmail.com
PostgreSQL version: 15.2
Operating system: Alma Linux 9.1
Description:
Need to eliminate files of /var/lib/pgsql/15/data/pg_wal/, because overcome
limit define in max_wal_size and this increase size used in hard disk
It is necesary to conserve files necesary to correct perfomance and
funcionality of database
Actual configuration:
PostgreSQL 15.2
max_wal_size=4GB
min_wal_size=1GB
wal_level=logical
checkpoint_timeout=5min
wal_compression=off
shared_buffers=2560MB
archive_mode=off
du -sh /var/lib/pgsql/15/data/pg_wal/ obtain size 213GB
find /var/lib/pgsql/15/data/pg_wal/ -type f | wc -l obtain numbers of files
13581
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-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, marle.saransig@gmail.com
Subject: Re: BUG #18821: Need delete files in pg_wal, size is bigger overcome limit max_wal_size
In-Reply-To: <18821-fd87033e4102cf03@postgresql.org>
* 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