Re: BUG #18821: Need delete files in pg_wal, size is bigger overcome limit max_wal_size

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
>
>