Date: Fri, 9 Sep 2022 09:29:53 +0000
From: Victor Sudakov <vas@sibptus.ru>
To: pgsql-admin@lists.postgresql.org
Subject: Re: WAL storage when archive_command=''
Message-ID: <YxsHkUV0sTz2Gv7n@admin.sibptus.ru>
References: <YxrHeKWaNZpaJea9@admin.sibptus.ru>
 <aa76c4bc-b1ed-7e72-5b13-13c78852e420@jakobs.com>
 <YxrqVUY5dvXKMoIX@admin.sibptus.ru>
 <f2d8e2c8-178a-5cdf-17c0-89f07ebee3d1@gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <f2d8e2c8-178a-5cdf-17c0-89f07ebee3d1@gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/YxsHkUV0sTz2Gv7n%40admin.sibptus.ru>
Precedence: bulk

Ron wrote:
> On 9/9/22 02:25, Victor Sudakov wrote:
> > 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.
> 
> How are you going to prevent the disk from filling up?

Someone will eventually set archive_command to something useful before
the disk is full. Or Postgress will stop. It does not matter for the
current question.

I just want to make sure that unarchived WAL files are never ever
deleted and there is no limit on the number or size of unarchived WAL files.

-- 
Victor Sudakov VAS4-RIPE
http://vas.tomsk.ru/
2:5005/49@fidonet