pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #18821: Need delete files in pg_wal, size is bigger overcome limit max_wal_size
3+ messages / 3 participants
[nested] [flat]
* BUG #18821: Need delete files in pg_wal, size is bigger overcome limit max_wal_size
@ 2025-02-20 17:42 PG Bug reporting form <noreply@postgresql.org>
0 siblings, 2 replies; 3+ messages in thread
From: PG Bug reporting form @ 2025-02-20 17:42 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: marle.saransig@gmail.com
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: BUG #18821: Need delete files in pg_wal, size is bigger overcome limit max_wal_size
@ 2025-02-20 19:33 Marlene Saransig <marle.saransig@gmail.com>
parent: PG Bug reporting form <noreply@postgresql.org>
1 sibling, 0 replies; 3+ messages in thread
From: Marlene Saransig @ 2025-02-20 19:33 UTC (permalink / raw)
To: marle.saransig@gmail.com; pgsql-bugs@lists.postgresql.org
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
>
>
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: BUG #18821: Need delete files in pg_wal, size is bigger overcome limit max_wal_size
@ 2025-02-21 10:51 hubert depesz lubaczewski <depesz@depesz.com>
parent: PG Bug reporting form <noreply@postgresql.org>
1 sibling, 0 replies; 3+ messages in thread
From: hubert depesz lubaczewski @ 2025-02-21 10:51 UTC (permalink / raw)
To: marle.saransig@gmail.com; pgsql-bugs@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2025-02-21 10:51 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-02-20 17:42 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-20 19:33 ` Marlene Saransig <marle.saransig@gmail.com>
2025-02-21 10:51 ` hubert depesz lubaczewski <depesz@depesz.com>
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