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 1r52iU-00BYXF-Ey for pgsql-general@arkaria.postgresql.org; Mon, 20 Nov 2023 11:45:26 +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 1r52iQ-0089N7-IS for pgsql-general@arkaria.postgresql.org; Mon, 20 Nov 2023 11:45:22 +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.94.2) (envelope-from ) id 1r52iP-0089Mz-QJ for pgsql-general@lists.postgresql.org; Mon, 20 Nov 2023 11:45:21 +0000 Received: from smtp.burggraben.net ([2a01:4f8:140:510a::3]) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r52iM-006T28-CA for pgsql-general@lists.postgresql.org; Mon, 20 Nov 2023 11:45:20 +0000 Received: from sciurus.exwg.net (unknown [IPv6:2001:470:7120:1:826d:97ff:fe4b:c7af]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client CN "sciurus.exwg.net", Issuer "R3" (not verified)) by smtp.burggraben.net (Postfix) with ESMTPS id 8A8E0C00317; Mon, 20 Nov 2023 12:45:15 +0100 (CET) Received: by sciurus.exwg.net (Postfix, from userid 1000) id 21DFF433CD8D; Mon, 20 Nov 2023 12:45:15 +0100 (CET) Date: Mon, 20 Nov 2023 12:45:15 +0100 From: Christoph Moench-Tegeder To: Matthias Apitz Cc: pgsql-general@lists.postgresql.org Subject: Re: pg_basebackup Message-ID: References: MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline In-Reply-To: User-Agent: Mutt/2.2.12 (2023-09-09) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ## Matthias Apitz (guru@unixarea.de): > 2023-11-16 20:34:13.538 CET [6250] LOG: terminating walsender process due to replication timeout Besides "what Lauenz said" (especially about the horribly ooutdated PostgreSQL version): check IO speed and saturation during backup and make sure you're not stalling. I've seen this beaviour a few times, mostly in conjunction with btrfs - using a suitably proven filesystem usually solved the problem (overloaded hardware can be a problem, too - but modern systems can take quite a bit more than in the olden days of spinning rust). Regards, Christoph -- Spare Space.