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 09:29:53 |
Message-ID: | YxsHkUV0sTz2Gv7n@admin.sibptus.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)fidonet
From | Date | Subject | |
---|---|---|---|
Next Message | Leandro Bugalho | 2022-09-11 06:08:36 | Re: WAL storage when archive_command='' |
Previous Message | Ron | 2022-09-09 09:21:04 | Re: WAL storage when archive_command='' |