Thread

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

   PG Bug reporting form <noreply@postgresql.org> — 2025-02-20T17:42:40Z

   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
   
   

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

   Marlene Saransig <marle.saransig@gmail.com> — 2025-02-20T19:33:35Z

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

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

   hubert depesz lubaczewski <depesz@depesz.com> — 2025-02-21T10:51:14Z

   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