[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-general
Subject: Re: Wal files in /pgsql/14/main/pg_wal not removed
From: Lucas <root () sud0 ! nz>
Date: 2021-12-26 23:09:47
Message-ID: 03A3850F-3B67-40A5-B66B-11BD137FA271 () sud0 ! nz
[Download RAW message or body]
> On 27/12/2021, at 5:14 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> Lucas <root@sud0.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
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic