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 1t2jcx-006glc-5T for pgsql-admin@arkaria.postgresql.org; Mon, 21 Oct 2024 04:02:43 +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 1t2jcv-004AS0-2m for pgsql-admin@arkaria.postgresql.org; Mon, 21 Oct 2024 04:02:41 +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 1t2jcu-004ARU-JU for pgsql-admin@lists.postgresql.org; Mon, 21 Oct 2024 04:02:41 +0000 Received: from mail-pf1-x431.google.com ([2607:f8b0:4864:20::431]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1t2jco-001wPb-E0 for pgsql-admin@lists.postgresql.org; Mon, 21 Oct 2024 04:02:39 +0000 Received: by mail-pf1-x431.google.com with SMTP id d2e1a72fcca58-71e983487a1so2801874b3a.2 for ; Sun, 20 Oct 2024 21:02:34 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1729483353; x=1730088153; darn=lists.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=7Ua7+aUmP8fJ5A52ixmiYtpliM1o1+QhY9YNYLVs8TM=; b=Udg6yniQgVirmZZR8ftZw/1vSUUTAzlL7AerzXps+ntFrxyssJIcTtNsLChT42xxTb 4BV135Zttupc7LOZQM/DR9Yggb6oCXRVCuWDtHyqU7mUBcc1RH0cVCYsnkoN9B+wWQDd zj0THfln4zxB/hZ4/Lxyl2vZPNCeHhbt5ZWGzOb6sTJJHdAI+s9uaqmkdamWGs4HrSsv bbbtbB8jV1B+JWXfYGvEqs3MA0UVJwehQKIgiiog/3X16lIiOIAc2p65L8ZvAHNPzD4O 7Io0AAVgCmqnyKrd8SM/8MIKef2KdvOo2eYwi8T06Wtdir/E89uNMESvQs5xBdeMk+/1 Ncww== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1729483353; x=1730088153; 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=7Ua7+aUmP8fJ5A52ixmiYtpliM1o1+QhY9YNYLVs8TM=; b=iOC0Rfu8OenYZzFjkCsK6HK6PB6/Fw9LeC5wJb2igNU0TPsR2H6wP3GEhOldDHQzC2 Dt2ucv0n8v2uN9LkVQH0zCUSxGboF3udTa0DTcDouknpu9F9G5gLaJP+5c+C31g3tLwq tJj0+1QWEa6i4rNpq0b4gTbAF2T3yB8ApJBlNrqEOcCWnprKqyUV0GAJOCQde/pwXk3O VnBlNYbstl3wVkCUMqUpXk3CaFi8ocOjnEdKoXWL8HqJQVgHtAI3BX/zaRJGsSZG7gZG m802PVLpouU9Tjy9jZXPfkijIitefpUegmO+hLxeQWQG8IMm7Ov7bZwoRGYihp0EJsaZ qXrA== X-Forwarded-Encrypted: i=1; AJvYcCVD1uu0hzKR0XmIumm3fJ0vF4B8dB5+wepQozryIX4M8jpEtCTLkjfSHc6zyKiuvcs+qQrCFG/o29j/tA==@lists.postgresql.org X-Gm-Message-State: AOJu0YzLT/bvgFch3NRRPn7IeOBCnXbgAOq5iv19CZ2BvzYjTM+R0jWa sBzS6Bzjuhso87SLQ1pQLp6TMDwY4gJOBepaBYn3mDeklWsYapoUozZA9E2mMCKPNPctlCfDU/v gzqNSApF77YGc6SRqQkZ/MDoUHZ8= X-Google-Smtp-Source: AGHT+IGqokbxAx5O9+7++sYapw4pyRhKXhF5UmKclMcjvblWjZuTiYM9BT7lhKUV0ios2hTlKbfhJE9PM9SMDYGtvYQ= X-Received: by 2002:a05:6a00:1913:b0:71e:4c01:b3da with SMTP id d2e1a72fcca58-71ea31d28dfmr14178702b3a.5.1729483353254; Sun, 20 Oct 2024 21:02:33 -0700 (PDT) MIME-Version: 1.0 References: <00ea01db1fca$aabbc990$00335cb0$@incisivetechgroup.com> In-Reply-To: From: Muhammad Ikram Date: Mon, 21 Oct 2024 09:02:22 +0500 Message-ID: Subject: Re: Backup Information To: SOzcn Cc: lennam@incisivetechgroup.com, Pgsql-admin Content-Type: multipart/alternative; boundary="000000000000ea73130624f4b85d" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000ea73130624f4b85d Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi, Could you use SELECT * FROM pg_stat_progress_basebackup ; Regards, Ikram On Sat, Oct 19, 2024 at 1:01=E2=80=AFPM SOzcn = wrote: > does anyone can share the experience of it? > > 16 Eki 2024 =C3=87ar 17:00 tarihinde SOzcn = =C5=9Funu > yazd=C4=B1: > >> As a application using ; >> https://documentation.commvault.com/11.20/configuring_virtual_server_age= nt.html >> >> SOzcn , 16 Eki 2024 =C3=87ar, 16:45 tarihind= e >> =C5=9Funu yazd=C4=B1: >> >>> Mostly v14 and 15 some of one v9-10 but first of all v14-15 >>> >>> As I see on the backend it's using pg_basebackup and dumpbased. >>> >>> 16 Eki 2024 =C3=87ar 15:55 tarihinde =C5= =9Funu >>> yazd=C4=B1: >>> >>>> Let me know the version PostgreSQL , I will provide SQL to get the >>>> details from system catalog tables >>>> >>>> >>>> >>>> *From:* SOzcn >>>> *Sent:* Wednesday, October 16, 2024 3:59 AM >>>> *To:* Pgsql-admin >>>> *Subject:* Backup Information >>>> >>>> >>>> >>>> Hello, >>>> >>>> We are currently handling backup processes for PostgreSQL through a >>>> company. >>>> >>>> I would like to monitor the backups on the database, but I have not >>>> been able to monitor the relevant query on WAL. >>>> >>>> Could you please assist with this matter? >>>> >>> --000000000000ea73130624f4b85d Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi,

Could you use

<= div>SELECT * FROM pg_stat_progress_basebackup ;

Regards,
Ikram




On Sat, Oct 19, 2024 at 1:01=E2=80=AFPM SOzcn <selahattinozcnma@gmail.com> wrote:
<= blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-l= eft:1px solid rgb(204,204,204);padding-left:1ex">

does anyone= can share the experience of it?


16 Eki= 2024 =C3=87ar 17:00 tarihinde SOzcn <selahattinozcnma@gmail.com> =C5=9Funu = yazd=C4=B1:
As a application using ;=C2=A0https://documentation.commvault.com/11.20/configuring= _virtual_server_agent.html

SOzcn <selahattinozcnma@gmail.com<= /a>>, 16 Eki 2024 =C3=87ar, 16:45 tarihinde =C5=9Funu yazd=C4=B1:

Mostly = v14 and 15 some of one v9-10 but first of all v14-15

As I see on the backend it's using pg_basebackup and dum= pbased.


16 Eki= 2024 =C3=87ar 15:55 tarihinde <lennam@incisivetechgroup.com<= /a>> =C5=9Funu yazd=C4=B1:

Let me know t= he version PostgreSQL , I will provide SQL to get the details from system c= atalog tables

=C2=A0<= /p>

From: SOzcn <selahattinozcnma@gmail.com= >
Sent: Wednesday, October 16, 2024 3:59 AM
To: Pgs= ql-admin <pgsql-admin@lists.postgresql.org&= gt;
Subject: Backup Information

=C2=A0

Hello,
We are currently handling backup processes for PostgreSQL through a c= ompany.

I would like to monitor the backups on the database, but I h= ave not been able to monitor the relevant query on WAL.

Could you pl= ease assist with this matter?

--000000000000ea73130624f4b85d--