Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oWaEf-00039t-8A for pgsql-admin@arkaria.postgresql.org; Fri, 09 Sep 2022 09:23:41 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oWaEe-0003I8-59 for pgsql-admin@arkaria.postgresql.org; Fri, 09 Sep 2022 09:23:40 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oWaCG-00063F-Ec for pgsql-admin@lists.postgresql.org; Fri, 09 Sep 2022 09:21:12 +0000 Received: from mail-oa1-x30.google.com ([2001:4860:4864:20::30]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1oWaCC-0006hU-PA for pgsql-admin@lists.postgresql.org; Fri, 09 Sep 2022 09:21:10 +0000 Received: by mail-oa1-x30.google.com with SMTP id 586e51a60fabf-12ab0eaa366so2317372fac.13 for ; Fri, 09 Sep 2022 02:21:08 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=content-transfer-encoding:in-reply-to:from:references:to :content-language:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date; bh=3s7rCSYQOXeJ0JU3xGtenswyuH4NniNgc78miPVfWNU=; b=EgFBAG/9sgoX5MJVxTXJ8IS7Qo1DhrMvyNiGSsDKBUqBBfWjUIEnfPVTEPGh/0uj4e f+7F/vx+54w0e3gmkrUkd4GcOR2xZ72ujzGRg8gRBBzc8ww5NmWMU7+WpCyrC8CBmrvO MB6a4Q0PJ7QgtT44rTpUDXqRIkVXMT08UGkRucF7iGzAdc/yJCQE77Q+sAKGQsn6Jw0v rW52Mj2nJ4Kbqra8Num+5Fmha/frqA7hGgcdC4x+71nyTSufEKY3H5x7JIDnoq25HoTi myfd66/sV3e0SeAVzvDtGloiQaulJIWesh8Tea6Uajj3g0S601pQlzBXWfHvgaoftm0J 1aLA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=content-transfer-encoding:in-reply-to:from:references:to :content-language:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date; bh=3s7rCSYQOXeJ0JU3xGtenswyuH4NniNgc78miPVfWNU=; b=U19GOIQqqYXvReokdl0WO3iT68c8I75sVSAphV0DG7VjvFBRWGKjnF28QwJnEtaLVN RrGUnzd991WgsQSmLA3vVbL2mB9e0kl/u7jPwqhELkkb05z4gxRQbDw3/LepADj26xlE QG2a0eGWOlT/bskz6LfnYTbDctRXcYSbWDerELS5aTZx3qBkk4926nOfPnAf7P743KRX V3ykFaKsOkht5aJij+XJglK0AKoKj966wlquQviOSslqyFJQJOUZpiA4aExib5oddZxw XTvaG/Qzvww6Wf2vp7VhgU6rtHp72sxa6x6AJFB+aw5oE0UIFvltViPBHpDup5xk9ZP0 blwg== X-Gm-Message-State: ACgBeo2ckHI/LXUAvUtS/Wt4BKRHYyhz6VfRmo4jj8JBidN6OMRZH2VH z1E8E+M9B6lURIWXjNU83Ufoy56sYkY= X-Google-Smtp-Source: AA6agR7ryy+4eYTjGisCOPkZjZg8ZyVdJ+4GY4s5eEp7sw7uRiq4ryPkyATXxiEOnhHF5TgNDS+AcA== X-Received: by 2002:a05:6870:2112:b0:127:76f4:83c4 with SMTP id f18-20020a056870211200b0012776f483c4mr4022171oae.171.1662715266355; Fri, 09 Sep 2022 02:21:06 -0700 (PDT) Received: from [192.168.88.10] (ip68-11-68-85.no.no.cox.net. [68.11.68.85]) by smtp.googlemail.com with ESMTPSA id q4-20020a9d57c4000000b0063ed39d585esm752731oti.45.2022.09.09.02.21.05 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Fri, 09 Sep 2022 02:21:05 -0700 (PDT) Message-ID: Date: Fri, 9 Sep 2022 04:21:04 -0500 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101 Thunderbird/91.9.1 Subject: Re: WAL storage when archive_command='' Content-Language: en-US To: pgsql-admin@lists.postgresql.org References: From: Ron In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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? -- Angular momentum makes the world go 'round.