Re: Wal files in /pgsql/14/main/pg_wal not removed

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Lucas <root(at)sud0(dot)nz>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Wal files in /pgsql/14/main/pg_wal not removed
Date: 2021-12-26 16:14:49
Message-ID: 1336159.1640535289@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Lucas <root(at)sud0(dot)nz> writes:
> My /pgsql/14/main/pg_wal directory is filling up. The server is not respecting the wal_keep_size = 100GB. I have no replication slots in this server, and I have already restarted PostgreSQL.
> I don’t know what else to look for. Would appreciate any help.

> archive_mode = on
> archive_command = '/pgsql/pg-archive-wal-to-slaves.sh "%p"'

You have archive_mode on, so WAL files will not be removed until
your archive_command reports success. Poke around in what that's
doing.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lucas 2021-12-26 23:09:47 Re: Wal files in /pgsql/14/main/pg_wal not removed
Previous Message amihay gonen 2021-12-26 12:43:23 Re: storing zipped SQLite inside PG ?