From: | Lucas <root(at)sud0(dot)nz> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
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 23:09:47 |
Message-ID: | 03A3850F-3B67-40A5-B66B-11BD137FA271@sud0.nz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> On 27/12/2021, at 5:14 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> 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
Thanks for your reply.
I removed my script and set an archive_command with a sample cp and it’s working now. Indeed my script has some issues.
Thanks again!
Lucas
From | Date | Subject | |
---|---|---|---|
Next Message | Alexey Murz Korepov | 2021-12-27 08:55:27 | Deprecating plans for PGPASSWORD environment variable as insecure |
Previous Message | Tom Lane | 2021-12-26 16:14:49 | Re: Wal files in /pgsql/14/main/pg_wal not removed |