Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tBaR0-004oVM-Gu for pgsql-general@arkaria.postgresql.org; Thu, 14 Nov 2024 14:02:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tBaQv-003kKR-Vy for pgsql-general@arkaria.postgresql.org; Thu, 14 Nov 2024 14:02:54 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tBaQv-003kKJ-J0 for pgsql-general@lists.postgresql.org; Thu, 14 Nov 2024 14:02:54 +0000 Received: from mail-oi1-x234.google.com ([2607:f8b0:4864:20::234]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tBaQs-001uGm-H2 for pgsql-general@postgresql.org; Thu, 14 Nov 2024 14:02:53 +0000 Received: by mail-oi1-x234.google.com with SMTP id 5614622812f47-3e6010a3bbfso346937b6e.2 for ; Thu, 14 Nov 2024 06:02:51 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1731592969; x=1732197769; darn=postgresql.org; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=crPvpCyu4wyDnGi0gloipScLEyJI/p7IfpcTpYeEZ3U=; b=MYwEg0GkZD/FsZToytzjBMTzoNQQ6KoFJ2MOe3+bzk5NNbNYSAfxDverG3y9aJBWu9 cHWQPTU9t2Epw2shaETcsaLtG1kPqqwTh3xbSTeRc6eZp7Ri9XCoWBXTJQSpHlGPISKG 1ENl4HwZA78NMDj8IMmG/BkAHv88kgjFd2L1xC7U+VMoEf/ms/MxfP/sIgtcpqvVAj5y LPQ/O6ZxPkoya7pad8UvVV69V30cvZEUObRQo2xcx02xG0YrRpC5ar0FXUCxBBrAAXrK u8S9i6gmFuiTrzSIY/V/83JNqC+5izXuczBQOJJMyxkH6RIEtSNGNI6jur4wwejOnyaK mJ3Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1731592969; x=1732197769; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=crPvpCyu4wyDnGi0gloipScLEyJI/p7IfpcTpYeEZ3U=; b=jYu2Jm6MW7IFxiG4KCg6lZaXoROWWvUxqXTMA6AFlY3j+DzwZpC5NhYW0dqUqiTHCq nzXh0AHexCXI+shC4M9udLSAHiWytT65GcnQSM1aVTZfZeOgaOm4Xqdpr9hk0LK8p9xh asc+E9ejUEXnlnzpKs+DPUwpqEPTSCAtv20TzqlCaYRftOXaItjAuVhpHVwyr3epMhNt BB376CsJRATzUlE1KN9mYAgedtgiUDWuiLWV3jSjdPO38fzZiT1W2S/IDp2c+vNogDMk snVvjc8uNPunLVkLWtFpeYTrWnuatfZJiGp50Jbax5T08b00eaQNMXkdnhFXYGlPkQZN IrMQ== X-Forwarded-Encrypted: i=1; AJvYcCWFg0zOu6ti2cfgON3Du0HFbKPraC33T+GG0csb23UtDv3J5lDHX0VQjIS7T5+Q81XXAk4h+/+cG/NU13m1@postgresql.org X-Gm-Message-State: AOJu0Yz4dc3MK1VyqbwTERHGm26WaKNsunqdDHdpnGma2NBFofKd12hn Cs4r4pAAg3Kgm95pbp4ovFXDJoJcnKx2746+1ofa9cqK0YSvIUnlT7ujgIfDHcZ7Ta25dBUdP8q YnN6X6zbnUCDob+m2YWl+rpkY3WU= X-Google-Smtp-Source: AGHT+IET4xMrbKpTagBhCmkJOfhOoFW5GTObURP8ehhfGl/NnJ9O77sHfqoKBvZO2LPwSfyTfeB2/oiLs8IJAYwgBak= X-Received: by 2002:a05:687c:270d:b0:296:1e98:6846 with SMTP id 586e51a60fabf-2961e99830emr589852fac.40.1731592969569; Thu, 14 Nov 2024 06:02:49 -0800 (PST) MIME-Version: 1.0 Received: by 2002:a05:6802:27c2:b0:56c:c9af:3ee6 with HTTP; Thu, 14 Nov 2024 06:02:48 -0800 (PST) In-Reply-To: References: <303a72f9-19f8-4ea8-bded-416632ba6c72@aklaver.com> From: "David G. Johnston" Date: Thu, 14 Nov 2024 07:02:48 -0700 Message-ID: Subject: Re: DB wal file disabled --_Query To: jayakumar s Cc: Adrian Klaver , "pgsql-general@postgresql.org" Content-Type: multipart/alternative; boundary="000000000000d8d24b0626dfe76c" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000d8d24b0626dfe76c Content-Type: text/plain; charset="UTF-8" On Thursday, November 14, 2024, jayakumar s wrote: > > Archive mode is already disabled. If more wal files will generate fs also > reached 100 percent based on application data load. > > As updated archive enabled or disabled. Will any state wall file that > will be generate correct? > WAL files are removed once they are no longer needed by the system. If they are not being removed you have an issue you need to debug to figure out why they are staying around. David J. --000000000000d8d24b0626dfe76c Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Thursday, November 14, 2024, jayakumar s <kumardba27.postgresql@gmail.com> wrote:
<= blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px= #ccc solid;padding-left:1ex">

Archive mode = is already disabled. If more wal files will generate fs also reached 100 pe= rcent based on application data load.

As updated=C2=A0archive enable= d or disabled. Will any state wall file that will=C2=A0be generate correct?=

WAL files are removed once they are = no longer needed by the system.=C2=A0 If they are not being removed you hav= e an issue you need to debug to figure out why they are staying around.

David J.
=C2=A0
--000000000000d8d24b0626dfe76c--