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.96) (envelope-from ) id 1vV26w-00CG0a-1l for pgsql-admin@arkaria.postgresql.org; Mon, 15 Dec 2025 06:31:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vV26v-00Fw3P-1l for pgsql-admin@arkaria.postgresql.org; Mon, 15 Dec 2025 06:31:10 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vV26v-00Fw1h-0R for pgsql-admin@lists.postgresql.org; Mon, 15 Dec 2025 06:31:09 +0000 Received: from mail-wm1-x331.google.com ([2a00:1450:4864:20::331]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vV26t-000jmK-2v for pgsql-admin@postgresql.org; Mon, 15 Dec 2025 06:31:09 +0000 Received: by mail-wm1-x331.google.com with SMTP id 5b1f17b1804b1-47774d3536dso30109275e9.0 for ; Sun, 14 Dec 2025 22:31:07 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1765780266; x=1766385066; darn=postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=umWpUYERzlHmusxKZSy1QSg0XVtRQTKHzbK0/0NT6OU=; b=db0Y27MVa2AXpUIlDUf3dflt0Wjd2v/LcrrM8/I3KLN3UGTrtid3UntT0zJbMttva0 1Ev/2atrs3XeIywlINu1mPgBVSnYAVLY8SBvH6GescKAgoudyf6WmhwaoZqSBexqbRnP ZZTKL0QP+jswr2TYI0MiONtsU2YjmTKeelJfejFoKNorbxzoR1KZ5VBhit0On4FKUNng bIVITKbptU3MjMlYzOx4UbArbTa6SddozKVAzTko5dy/Aw6A4I8ke34q7ha6vojRSgfa Scy8pdyewQB/RzCrmhW1YNsturm3aZQDFGaQkYa6v/V/dt68B5KGVauhGie8LgC37wyJ R1vA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1765780266; x=1766385066; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=umWpUYERzlHmusxKZSy1QSg0XVtRQTKHzbK0/0NT6OU=; b=E7uwnFd2pv0FSBj4Nv4NMe5dGbfUIVG4sV1GtztIPR043jntkQxuVaNZtUQrD5i/ea 19+jJBo5hCYN2ewws8kBaiFqVI10jeXpSVGEfjv5/p+4DhxyJnh4zjoEnW1y4ssmYooZ XAC1lWliEj8Fi1TbUjatDf1QBntSR62mAPfsJXDYslyx2BQgxO7ukBxskNbsnpvyHLWj 86p9IqYkLTSO/paER2Wo1j+HYVng0YXsN1OA8X+lFYXwhP6K6u4rAVe5fJkX7hzp6X/g O6Oea2wR7Ms+RKelaWN3uXpYBHU3y9jvIevEuWNpP8J5eZ+w/DKAy0H67alcEyWeEtzU WZMA== X-Forwarded-Encrypted: i=1; AJvYcCVl5ruR2PEiBzrOJ64gPUn9Q1tqdl8JhPP1C5jTfF756AeoIdApbKk9dEu8Ny+3+6r70ZdwD4umoBmOmw==@postgresql.org X-Gm-Message-State: AOJu0YxIVwecuwoVkwv8So9NASdoKt3Ti/N7VUC9bQp+shkUAGnqRCVc eAu5SUlG+Fu34fd5dVufmSIyvY4caenkxf0PPhpCqh9CVW95jh4Ij4LQ9mKP32j+MD4QraWBCOK hA0XR X-Gm-Gg: AY/fxX6Fr7U0HxTsJK5WJCVoOyDecjMhLduWdd1qQvdz7RBNCveGB7G5Wfa+y8uQCaI a0PCbxHV3hmFXXzLy+OjnvM6IsMuE4hzaULC2YK12uPpDaVaXUde/PnSS9FCknJtcIIrsIb2DRH Xj/YU9ZUiMPyrV9/5sVeIdThz37ZUR60eY2KRvAw50VDnizQDvO+IkucyWwr9d2nr6VJOovZDjl 6W3vZCQwq924PF0qkOG98VJuYIlIBPZl9UkIMlRfskrmawFDdvkEv1VvmFZXdL2b4tdPyXJZhI1 oVjvUIXb5H3TiDE4+EhJ9yncrAcvxoYyUeObIXgD7Hj18Pvs5peH94Udbpx1/Q/khBuLVWQodn3 vB8Wp0tA3pPEqX1S9d+Oel0K+5kpdA6ghn8BIXbq1oJhsxvJ8uRJKFyeZBfaIoOVYNJeYP+ZOuO K1YP7dnS7jxTzfjlarRAIIiDE/tvlNBn+FJmxchq4swBQ= X-Google-Smtp-Source: AGHT+IEU4PNiWqlDzgOsoO5BRrQUwjwFE0retwcMxrBQlidlXPj+oolZ6FTDO9ugYU9Qbq0GaXuLaA== X-Received: by 2002:a05:600c:3ba3:b0:477:a219:cdc3 with SMTP id 5b1f17b1804b1-47a8f1c33c5mr117145125e9.12.1765780266121; Sun, 14 Dec 2025 22:31:06 -0800 (PST) Received: from laurenz.albe-K4N0CV00F97414D ([2001:871:270:4cf9:1875:33eb:6694:f468]) by smtp.gmail.com with ESMTPSA id 5b1f17b1804b1-47a8f8e9115sm170490425e9.12.2025.12.14.22.31.05 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Sun, 14 Dec 2025 22:31:05 -0800 (PST) Message-ID: Subject: Re: Wal file increase From: Laurenz Albe To: kasem adel , pgsql-admin Date: Mon, 15 Dec 2025 07:31:05 +0100 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.56.2 (3.56.2-2.fc42) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Sun, 2025-12-14 at 17:30 +0200, kasem adel wrote: > Appreciate your usual support that we facing an issue when take pg_baseba= ckup for 4 TB > database in standby server and when backup finished we face huge number o= f wal file > with huge size generated for 6 hours the cause replication interruption. If you want help with that, you will have to give us enough information to = explain what happened. - What exactly is a "replication interruption", and how do you diagnose it? - Are you using streaming replication or logical replication? - If it is streaming replication, are you using a replication slot? - It is expected that if you suspend replication and have a replication slo= t, WAL will pile up on the primary. But what is the connection with pg_basebackup? Yours, Laurenz Albe