Re: WAL storage when archive_command='' - Mailing list pgsql-admin

From David G. Johnston
Subject Re: WAL storage when archive_command=''
Date
Msg-id CAKFQuwar9r_jQeLYnSHpL1A_8k2kV+NhMDHfHVA862sDr-cC-A@mail.gmail.com
Whole thread Raw
In response to Re: WAL storage when archive_command=''  (Victor Sudakov <vas@sibptus.ru>)
List pgsql-admin
On Friday, September 9, 2022, Victor Sudakov <vas@sibptus.ru> wrote:

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.


The docs clearly answer this IMO:

If archive_command is an empty string (the default) while archive_mode is enabled, WAL archiving is temporarily disabled, but the server continues to accumulate WAL segment files in the expectation that a command will soon be provided.

Though I suppose I would argue to either remove the word temporarily or describe under what conditions, besides putting in a non-empty string, would re-enable it.  Additionally, change disabled to suspended since that doesn’t contravene the behavior of an enabled archive mode to never remove WAL without a successful execution of a non-empty archive_command.

David J.

pgsql-admin by date:

Previous
From: Leandro Bugalho
Date:
Subject: Error when execute insert/update
Next
From: Leandro Bugalho
Date:
Subject: Re: WAL storage when archive_command=''