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 1vBrDv-0062z9-DZ for pgsql-admin@arkaria.postgresql.org; Thu, 23 Oct 2025 09:03:06 +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 1vBrDu-007UCH-CX for pgsql-admin@arkaria.postgresql.org; Thu, 23 Oct 2025 09:03:05 +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 1vBrAb-007OMK-1h for pgsql-admin@lists.postgresql.org; Thu, 23 Oct 2025 08:59:40 +0000 Received: from mail-wr1-x42d.google.com ([2a00:1450:4864:20::42d]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vBrAY-003JlL-0p for pgsql-admin@postgresql.org; Thu, 23 Oct 2025 08:59:38 +0000 Received: by mail-wr1-x42d.google.com with SMTP id ffacd0b85a97d-3ee64bc6b85so478576f8f.3 for ; Thu, 23 Oct 2025 01:59:38 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1761209976; x=1761814776; darn=postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=GYKH93GIuASTERGzPuGTrED0XA41O2zGltOWxZBxNqM=; b=bOkQB83LXQccalbrQ4vlGw2Nh1NypdJ2cRAgk1F1hAeAdbJqfWBCxfgQiYDAYzBH9R wxMEIG/COUUu9NZ9ztfjeuxqTZcjTrMtz49uL9XrZpgeMX4v1WsKoQtFM4TeMe1IQqSl 0KzLXPP7yXuLKTupIgw9LfEYa7jDVXZNoMYlDmN5y7QL/PmgJsSZUNxIegHVAVRU8D89 072/xiV+UQihg9r1EPFP46IPlU5er7O3Dk/b7IlJ2iINbIsnbX8TypkI6IBQN/JhJH/o ZR7iL7UWnqgwluD4Z+Ot7P8ad7Vy54L+zVWgQc9DJo7pgJks2T2NhMvqKN/S6nrih+VF sV8g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1761209976; x=1761814776; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=GYKH93GIuASTERGzPuGTrED0XA41O2zGltOWxZBxNqM=; b=lDQeeZdoJgqj2U6NGVN2ezrkkCFcyDFaW9AHUjWxz0zsmutVhhxhjjCvYU55SFO/Ro rI+R09DlnVQGhvlHjt9O0LaYtR5X51aph0sgu94gVe/uycLksAuE8awBAdbBSdMbSqi+ P54w9IBFmFfYWN5vrZvvlsnt7ojevn3V7cvmQ4JZqUnu7UwVrR4ppuDTMRPUpXcfEdmt 1rWTg0V8mGhlZUfuWWsO5GVtfHgsXO0k9ep72Yp0o54xVF1/3xsITrUj/X/bN9jFgvVE auPr/Z5ALAxMJOH17cqpoOkj6DxMOz2s7fYnzaIIKIO12i34ePBj6AbxjLVZEElRiJ5F AQ3Q== X-Gm-Message-State: AOJu0Yz4GH+0ZABo4voLi0WY7LxFksLyOaVHVGki+OLSpqsi4/21c1iK B8K5fCils4hudiSeaJEFZTzpTAsWCrNY1HY43AGdqy9DdK1tMXQzIH/hG2IQaR13uRYOEfXGi5z p6hq3WfBN1dULt4FZXpctYWRF5v7I3B/SJyXNz18= X-Gm-Gg: ASbGncv5btpHuj0n9CFnbPc47fG4Hyce87gNLlEkppNILj0R6pECIX6UGu0JjZ1J3t0 IjGWUfdF06InR5Et97UCcvEtatlmKi0AIn1Pz4dckJhNmygL6ZXF75h4U6efMnnKRY4QsLf+sXO 59zsuCXXln171ocHdlbDwISZRpiXXlgbklsnr0ke10t2+BVOSg91rJ2jYVdrvXBSmaRNt+QE9Hg BQCHjsHZCunkAeHWU5W70rwMFT2SZv+0qz5PmyNca+a5UtPwcFELOehhSU4yxaN5dmTttal6n3D jYggINESH/atBfKYAwad0R4p1Uyup6qDgibCfA/i X-Google-Smtp-Source: AGHT+IFLWTnoFs33/zglsxdUF3IGY0yhtM9Vfc7zMX2c4sjoEvQUxNh6rNO0ZE56LFwIohZ4QDUvBi7wSN9EXUVJfYA= X-Received: by 2002:a05:6000:2003:b0:427:813:6a52 with SMTP id ffacd0b85a97d-42708136ad9mr15271754f8f.41.1761209975441; Thu, 23 Oct 2025 01:59:35 -0700 (PDT) MIME-Version: 1.0 From: =?UTF-8?Q?P=C3=A4r_Mattsson?= Date: Thu, 23 Oct 2025 10:59:23 +0200 X-Gm-Features: AWmQ_blddqy12MiMZ-hFQfro3l8jOY5zyCjOqZZewJ2Xj0Ds0TBdz1GxHmi6glM Message-ID: Subject: PGbackrest very slow! To: pgsql-admin Content-Type: multipart/alternative; boundary="000000000000f60c430641cfa6ea" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000f60c430641cfa6ea Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi! I have 3 node postgres cluster with repmgr and pgpool. Pgbackrest is configed like this We use pgbackrest with this config =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D [global] backup-standby=3Dy repo1-path=3D/postgresql/backup repo1-retention-full=3D2 start-fast=3Dy [PG] pg1-path=3D/postgresql/data pg2-host=3Dnode2 pg2-host-user=3Dpostgres pg2-path=3D/postgresql/data pg3-host=3Dnode3 pg3-host-user=3Dpostgres pg3-path=3D/postgresql/data =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D I run the backuplike this /usr/bin/pgbackrest --log-level-console=3Ddetail --stanza=3DPG --type=3Dful= l backup The backup of 50GB took 40 min. It is not a network issue. I tested to transfer 2GB between two host and it took 4 sec. I think backup-standby=3Dy slows down the backup out of all minds. Br P=C3=A4r --000000000000f60c430641cfa6ea Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi!I have=C2=A0 3 node postgres cluster with repmgr and pgpool.
Pgbackrest is configed like this
We use pgbackrest wi= th this config
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
=

[global]

backup-standby=3Dy

repo1-path=3D/postgresql/backup

repo1-retention-full=3D2

start-fast=3Dy

=C2=A0

[PG]

pg1-path=3D/postgresql/data

pg2-host=3Dnode2

pg2-host-user=3Dpostgres

pg2-path=3D/postgresql/data

pg3-host=3Dnode3

pg3-host-user=3Dpostgres

pg3-path=3D/postgresql/data

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D

I run the backuplike this


/usr/bin/pgbackrest --log-le= vel-console=3Ddetail --stanza=3DPG --type=3Dfull backup

=C2=A0

The backup of 50GB took 40 min.

It is not a network issue. I tested to transfer 2GB between two= host and it took 4 sec.


I think backup-standby=3Dy slows down the backup out of all minds.


Br P=C3=A4r

=C2=A0

--000000000000f60c430641cfa6ea--