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 1uAjK1-001QgI-Ke for pgsql-general@arkaria.postgresql.org; Fri, 02 May 2025 05:52:30 +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 1uAjJx-007NRl-Ja for pgsql-general@arkaria.postgresql.org; Fri, 02 May 2025 05:52:26 +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 1uAjJx-007NRd-2s for pgsql-general@lists.postgresql.org; Fri, 02 May 2025 05:52:26 +0000 Received: from mail-pf1-x42d.google.com ([2607:f8b0: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 1uAjJw-000dqM-0b for pgsql-general@postgresql.org; Fri, 02 May 2025 05:52:25 +0000 Received: by mail-pf1-x42d.google.com with SMTP id d2e1a72fcca58-736c277331eso2701459b3a.1 for ; Thu, 01 May 2025 22:52:24 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1746165143; x=1746769943; darn=postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=XRwn/fHGQQwxoouOQAgxrAqxqY2Un4MXMfrjbFZt4Io=; b=Nh4hsAL5T5wy0g8FgZLdAA01isWz/ed7pYJ8zkQ6aV0IBWuDmJ6wKeNoufpL05LI1j JYOwOF2oUNC8lgXP4MinQBcu420s2Z5hdwzTSHxQ23ubiE9LRgTjchatu0j95zNF+oLo fsScLpxyIjniHeEk8bhcrPHADPyk34/ax3luJ23XyTYlutdJvKjhtRfeqNCycKG2YxwY snyjp3QeA1fUTXno6bGmSdPQk2AXMEDGGJ3Gcf+SOVfCbUb5m2p1igVGFzB9fBfMDC8s Cl9KhB0Sl2nywaLbZYtQaV+erRIyptCcMlD/0wH8zdLUXYCw/So18NoPzkN/YuTiOiQz oDPg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1746165143; x=1746769943; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=XRwn/fHGQQwxoouOQAgxrAqxqY2Un4MXMfrjbFZt4Io=; b=qcMCIoB4Z+ffpmTuUy2qfYepB1/fUEMXBYQel3Ccw+W2cP+JXv0L4SD7d7P2vivGvt ndFg6QGiEoNSj5lvTxZI1sP4EG5aS1kpxYjsT7BkqBkm29TuxbpiAdvGJPHhzulsgui3 MZoZqRwiMiNJBsnGxOxCMnOwb0rTyIKnTw68UMmL8MvSu3RFve8tMIBFmmTt3EqpYEon Dv2791sR5Y1d2SYyEXgAMhs2yOGgcpAVBnQVc4rVWIav0ohwF4CeDqt0tJBEGnkSVzpA jd+TbchgVmkFfFypBgERTZ6wzQvMtzbgmKWOWtZNjN7qhuFoYbKANj7/uOT3GY3ovKGK IqTw== X-Forwarded-Encrypted: i=1; AJvYcCUF6Xlj0+aIdAXE7s8UT5y2RZCDI1KWaFqc+9T52VKRok91DnrkgR2dfzwdq7H3RQgcO3JefB6B0IoNvben@postgresql.org X-Gm-Message-State: AOJu0Yxz8bhdaNbSbE7WahzP9ZZBsG7gSW9gwiIrxnB3vcnpui6KGoWx Pg6V9MpAtOyXGssuMq9yo7saivoBvwfzl1IhVXlDMjnPZdCJasU9ngPhtu4tLCWOc0CM+BRXXHf R2AV/dBsUiB9PhO9SfNNqo/OaH/E= X-Gm-Gg: ASbGncuibh1K1xmWRBK4+vizrS0BE4i2Js3iQFoCsKgZAu7/TQlRqHz12IFXpKg+bYH kwkebGOfXxJ++I2UmFQqQmfD8XXIC1zekHoE4g1UbwbCKfsjOHfZDGIgdGRflFXzGvYKU3ahp/F BBI/SJBTVFwGsmm3CEGBEMwXA= X-Google-Smtp-Source: AGHT+IFrLDrmbma9HMQ1ofzt0NhLx4B+cecSPyzCDgsmynmLzEaP0betqD00RCIl2jLuQwLPYmnsLbx1DyF3FdiCV74= X-Received: by 2002:a17:90b:5247:b0:30a:204e:fe47 with SMTP id 98e67ed59e1d1-30a4e238283mr2999265a91.16.1746165143113; Thu, 01 May 2025 22:52:23 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Abdul Sayeed Date: Fri, 2 May 2025 11:22:11 +0530 X-Gm-Features: ATxdqUHtYvJg3WFVl73g-J21QAkDPv9hgklCQ-8sj7-tNUl-NGJjCzlZskj3Mx8 Message-ID: Subject: Re: Pgbackrest : Resumable backup of same type exists To: Greg Sabino Mullane Cc: KK CHN , pgsql-general Content-Type: multipart/alternative; boundary="000000000000131535063420c1ad" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000131535063420c1ad Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi Greg, My apologies but the above answer which i gave was not from chatgpt, I had face similar situation in one of our env. Deleting failed backup helped me. To be honest I did use chathpt to paraphrase my sentences before posting in general mail list. Thanks & Regards, Abdul Sayeed On Thu, 1 May, 2025, 11:13=E2=80=AFpm Greg Sabino Mullane, wrote: > On Thu, May 1, 2025 at 9:08=E2=80=AFAM Abdul Sayeed > wrote: > >> Hello, >> >> This warning message indicates that a *resumable backup*, >> > (plus lots more ChatGPT crap) > > Please do not use LLMs to answer questions here. If the original poster > wanted that, they could have done it themselves. Further, you are polluti= ng > the pgsql-general archives with computer-generated answers which will in > turn get slurped in again, leading to degradation. People posting here > deserve real answers from real people. > > /rant > > Original poster, I wouldn't expect it to take three+ hours, but we don't > know how large your backups are. Check /var/log/pgbackrest and see the > latest log entry - it looks like you have "debug" level enabled, so it > should be quite verbose. If the process is running but not writing anythi= ng > to the logs, you might want to use strace against its PID to verify what = it > is doing (if anything). > > Cheers, > Greg > > -- > Crunchy Data - https://www.crunchydata.com > Enterprise Postgres Software Products & Tech Support > > --000000000000131535063420c1ad Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

Hi Greg,

My apologies but the above answer which i gave was not from = chatgpt, I had face similar situation in one of our env. Deleting failed ba= ckup helped me.

To be honest I did use chathpt to paraphrase my sentences be= fore posting in general mail list.



Thanks & Regards,
Abdul Sayeed

On Thu= , 1 May, 2025, 11:13=E2=80=AFpm Greg Sabino Mullane, <htamfids@gmail.com= > wrote:
On Thu, May 1, 2025 at 9:08=E2=80=AFAM Abdul Sayeed <abdulsayeed24@gmail.com> wrote:
=
Hello,

This warning message indicates that a resumable backup,

(plus = lots more ChatGPT crap)

Please do not use LLMs to = answer questions here. If the original poster wanted that, they could have = done it themselves. Further, you are polluting the pgsql-general archives w= ith computer-generated answers which will in turn get slurped in again, lea= ding to degradation. People posting here deserve real answers from real peo= ple.

/rant

Original poste= r, I wouldn't expect it to take three+ hours, but we don't know how= large your backups are. Check /var/log/pgbackrest and see the latest log e= ntry - it looks like you have "debug" level enabled, so it should= be quite verbose. If the process is running but not writing anything to th= e logs, you might want to use strace against its=C2=A0PID to verify what it= is doing (if anything).

Cheers,
Greg
<= br>
--
Enterprise Postgres Software Products & Tech Supp= ort

--000000000000131535063420c1ad--