Re: WAL storage when archive_command=''

From: Victor Sudakov <vas(at)sibptus(dot)ru>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: WAL storage when archive_command=''
Date: 2022-09-09 07:25:09
Message-ID: YxrqVUY5dvXKMoIX@admin.sibptus.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)fidonet

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ron 2022-09-09 09:21:04 Re: WAL storage when archive_command=''
Previous Message Holger Jakobs 2022-09-09 06:43:09 Re: WAL storage when archive_command=''