Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #18821: Need delete files in pg_wal, size is bigger overcome limit max_wal_size - Mailing list pgsql-bugs

From Marlene Saransig
Subject Re: BUG #18821: Need delete files in pg_wal, size is bigger overcome limit max_wal_size
Date
Msg-id CACTVp0zm4MFxjMOEWgcNNntPwN_=cVf5Ewzy_PezN408Nr+RqQ@mail.gmail.com
Whole thread Raw
In response to BUG #18821: Need delete files in pg_wal, size is bigger overcome limit max_wal_size  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
Tree view
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

pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #18821: Need delete files in pg_wal, size is bigger overcome limit max_wal_size
Next
From: Tom Lane
Date:
Subject: Re: Major Version Upgrade failure due to orphan roles entries in catalog