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 1vV7TP-00DoiN-25 for pgsql-admin@arkaria.postgresql.org; Mon, 15 Dec 2025 12:14:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vV7TO-000BxQ-1r for pgsql-admin@arkaria.postgresql.org; Mon, 15 Dec 2025 12:14:43 +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.96) (envelope-from ) id 1vV7TO-000BxI-0f for pgsql-admin@lists.postgresql.org; Mon, 15 Dec 2025 12:14:43 +0000 Received: from mail-wm1-x336.google.com ([2a00:1450:4864:20::336]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vV7TM-000rM0-1u for pgsql-admin@postgresql.org; Mon, 15 Dec 2025 12:14:42 +0000 Received: by mail-wm1-x336.google.com with SMTP id 5b1f17b1804b1-4779ce2a624so37934225e9.2 for ; Mon, 15 Dec 2025 04:14:40 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1765800880; x=1766405680; 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=TNFsnfcpPeBVYSrIgCHj9hRRBbB5+WFvxvS24X9KmWA=; b=R7cXYob3wcaxaIVKsrMu5qJuj9ezj9uxB1us2Vephe3/hfgwfY5Cd0qeJv5Q3ixDi1 GZE+CcU/hL49bNmNFH4G33UJmkfFU2+7qDDGkw1eXZYtdDAMvNtU3RjEQ1na1GZvTxFc aEeKhzRMcsfRGb249LfOvbTBKB4KQ5wJARnmt4l1H8s7AuDss4LzhzP3EeXO6kjBWmoz 7n4NzURfvoPyAhyWWMOksCTDNDucGt0r5+2L7476v+no/su7SHx0HHRSeYZOLbumH8eP SrsEgjBIDI+Mk+NUwWPuwNVeqw+8ICZTR5sBsuxOIfpPUbgG/c3EgtsJPlfXDi6TSqCZ s4og== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1765800880; x=1766405680; 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=TNFsnfcpPeBVYSrIgCHj9hRRBbB5+WFvxvS24X9KmWA=; b=EsdzSWhCbfj3MoABqwd3lMMmtlpMWRHp5BMtYLgN9139Oc1+wGmmzl2w0fzruessJU Owih566yMY0y97L9Sdq+NCCOdrlw74ZN0ycsdOIhgLbH7xhRP0JeGZFdYls6KCE/XQLo SRNDM/HpoFSCfswa+wIv2V1mOSDTIjYkPyFT63ifLLLfabfRx4miW3EwDJel1ZvsRt6+ W9rf3LWKUv2TxHmsiU6GdBHGhK9/3BRzO26GvAF+NIVpveZDJLcebqH6gjVuNDEsVtd5 tn4x3utQmTzYSFNWQ4sMMsvtjGouYc4M70TbB0UIr7PJNs3Ibr9Ln9+0ByamAbAduhg6 JcXw== X-Forwarded-Encrypted: i=1; AJvYcCV9u09Prh8FuE9vqqV2iqKK853+sFfdslkd81ncwfUl6KMB7ika8amCklBmWX7OmUV4BYldA+MIJL53Lw==@postgresql.org X-Gm-Message-State: AOJu0YzIxHdd4w+iZ/ZJ23/m+hCvS/ipOdYYPlGrZLBFbARRNuGbzKVu ePQkbWDQ+PRRICDm9syExyCgqiXoRrCioDoP/qhhY/zUBrpG9bsu/ytBTeC7AFaoUfM= X-Gm-Gg: AY/fxX4nMIQo28wR2IejJRy1UccWjWSg6sm53sJPZNNmp2VMhUWXkyjDvP4mb4slqgW P3gWL7lX8gH/iCn3uJ6kqciohCNzUBeBQyti8mONwR2kbMp0oCeX49aDOJV96vJxdPOs1vBg24S cAvfGBJ/arVELrEOWBibceduAbyrtRX4iWXGyAb44NHVWfTI0ADOJwGPRMU4md1gGJ3wgZP+FqP dP33koR2+GJgY8boIeyiQwxfdc0/qCiYWcmIJCnRpRnmPdn7GZiSrGShcfkrFxuiMsMbUZeJixs O/OmJsQBiJyHH0TN7xcl3E0fIag1z4yiT4/t9pFwUmMov1KZzeKJXpFfRka4u85TJIcK98pjpfl 4c3yEYXJhXfvvo0LhGiXBqcaabQbx6WLJSfNgC0M+fmZZvk5DuknkV+VPVtwUiJzeAcVcqgvipD uii/FDZU4+CWQj7BLE8Qw/uyuAiWEh39KaFGoA7+uPKw== X-Google-Smtp-Source: AGHT+IGSh+io17pRJ6wG0VoZPDrxyxKl9lWqMH84sI5ojcc/VaOzMXbCi/FwON6JQjwBNUIFhboabg== X-Received: by 2002:a05:600c:1c87:b0:471:989:9d7b with SMTP id 5b1f17b1804b1-47a8f9071d2mr128533445e9.21.1765800879681; Mon, 15 Dec 2025 04:14:39 -0800 (PST) Received: from laurenz.albe-K4N0CV00F97414D ([2001:871:70:4d5d:eedd:3dd9:428c:9522]) by smtp.gmail.com with ESMTPSA id 5b1f17b1804b1-47a8f49da20sm182441595e9.5.2025.12.15.04.14.39 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 15 Dec 2025 04:14:39 -0800 (PST) Message-ID: Subject: Re: Wal file increase From: Laurenz Albe To: kasem adel , pgsql-admin Date: Mon, 15 Dec 2025 13:14:38 +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 Mon, 2025-12-15 at 08:19 +0000, kasem adel wrote: > > -What exactly is a "replication interruption", and how do you diagnose = it? > We see replication slot restart every time in these period I have never heard of a "replication slot restart"... > > - Are you using streaming replication or logical replication? > I have streaming replication for one node and another logical replication= =C2=A0 > > - If it is streaming replication, are you using a replication slot? > Yes have replication slot > > -=C2=A0It is expected that if you suspend replication and have a replic= ation slot, WAL will > > =C2=A0 pile up on the primary.=C2=A0 But what is the connection with pg= _basebackup? > Yes still exist. You probably need to hire an expert to have a look at your system and find out what *really* is going on there. Yours, Laurenz Albe