Thread: BUG #18821: Need delete files in pg_wal, size is bigger overcome limit max_wal_size
BUG #18821: Need delete files in pg_wal, size is bigger overcome limit max_wal_size
From
PG Bug reporting form
Date:
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
Re: BUG #18821: Need delete files in pg_wal, size is bigger overcome limit max_wal_size
From
Marlene Saransig
Date:
Use this command to eliminate files of pg_wal, but when execute this command, it doesn´t have desired result
sudo -u postgres /usr/pgsql-15/bin/pg_archivecleanup -d /var/lib/pgsql/15/data/pg_wal/ $(sudo -u postgres psql -Atc "SELECT pg_walfile_name(pg_current_wal_lsn());")
Additionally execute the command CHECKPOINT to force of elimination of old files
El jue, 20 feb 2025 a las 12:43, PG Bug reporting form (<noreply@postgresql.org>) escribió:
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
Re: BUG #18821: Need delete files in pg_wal, size is bigger overcome limit max_wal_size
From
hubert depesz lubaczewski
Date:
On Thu, Feb 20, 2025 at 05:42:40PM +0000, PG Bug reporting form wrote: > 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 You might want to read https://www.depesz.com/2023/06/18/why-is-my-wal-directory-so-large/ Generally, it's extremely unlikely to be a bug in postgresql. More likely misconfiguration or forgotten "thing" that is causing the issue. Best regards, depesz