From: Victor Sudakov <vas@sibptus.ru>
To: pgsql-admin@lists.postgresql.org
Subject: Re: WAL storage when archive_command=''
Date: Fri, 9 Sep 2022 07:25:09 +0000
Message-ID: <YxrqVUY5dvXKMoIX@admin.sibptus.ru> (raw)
In-Reply-To: <aa76c4bc-b1ed-7e72-5b13-13c78852e420@jakobs.com>
References: <YxrHeKWaNZpaJea9@admin.sibptus.ru>
<aa76c4bc-b1ed-7e72-5b13-13c78852e420@jakobs.com>
Holger Jakobs wrote:
>
> Am 09.09.22 um 06:56 schrieb Victor Sudakov:
> > Dear Colleagues,
> >
> > With archive_mode='on' and archive_command='', is there a limit on WAL
> > files accumulation or will they be kept infinitely until the disk is
> > full?
> >
> > Actually I'd prefer them to be kept infinitely, just want to make sure
> > it's really the case.
> >
> There is no limit. The disk will run full.
That's actually great that unarchived WAL files will never get
deleted or reused. Thank you for confirming this.
I was pretty sure about the situation when the archive_command returns
a non-zero status, but not so sure about an empty archive_command.
>
> That's why disk space is the #1 priority in monitoring a PostgreSQL
> instance.
--
Victor Sudakov VAS4-RIPE
http://vas.tomsk.ru/
2:5005/49@fidonet
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: vas@sibptus.ru, pgsql-admin@lists.postgresql.org
Subject: Re: WAL storage when archive_command=''
In-Reply-To: <YxrqVUY5dvXKMoIX@admin.sibptus.ru>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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