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 1tqitz-009K8E-BV for pgsql-general@arkaria.postgresql.org; Sat, 08 Mar 2025 01:22:55 +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 1tqitw-004Mc4-Vg for pgsql-general@arkaria.postgresql.org; Sat, 08 Mar 2025 01:22:52 +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.94.2) (envelope-from ) id 1tqitw-004MWb-IP for pgsql-general@lists.postgresql.org; Sat, 08 Mar 2025 01:22:52 +0000 Received: from mail-oi1-x236.google.com ([2607:f8b0:4864:20::236]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tqitt-001bNF-0G for pgsql-general@lists.postgresql.org; Sat, 08 Mar 2025 01:22:52 +0000 Received: by mail-oi1-x236.google.com with SMTP id 5614622812f47-3f3edbef7d2so768721b6e.2 for ; Fri, 07 Mar 2025 17:22:49 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1741396968; x=1742001768; 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=uvL3d34YZ5Gm2tmrVp62pnmUi233P5cvxcUjgcXueAg=; b=iev0kjAMQ+ZUNoWts+DsByo5V8+Ah6usLROPvnuvqzszgVRDOk/0y4aXpQiAH7fTfA /ShCu8ccvsqU4sOfo/C34h5TaFSAS5ABWwY5MtBCQn8goOxXqhhaJoaTnWx5g7dL6EZ0 Qr0VZ/B0wBBEAbxg9DPp1sNrFmI15IrCcQ6u1rdtk4vn+BqMBDxjveV1WbrIHNjtgfTJ Xs8D41ouyZgtiJPNazBgLaoGnTt83Ye5x9/odGv52VxTDH0woE1mAQ5Ie5Bf9sZB0M0L TeUCT32H9G6OeT6e9AM5LXeoocAwrXWI3D6BzCk0Waxhvr8J9S6pWGEyP7BcR1JN98V3 M+Vg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1741396968; x=1742001768; 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=uvL3d34YZ5Gm2tmrVp62pnmUi233P5cvxcUjgcXueAg=; b=eZ4G1opkSplq4uHTtmUpbt30aiC+H6hNIh6wmiAgnxZOE6leWyv5PS3+nf1PQvVS0o kiZHQTeOgbcT3IIVAgLaKh9VNNBM0l7C0/ZB5GmUaNhS89TjKXnp60eX+DpD+pi7Du5l q3pH3uUOdQjOP/u5gPZD8rzyZk68NAolejtnBzUtvP/kdjPCUv5N0vYNUOTJB2LVHcPl 7IRVl7o+q2NFeM/kP97elw2AgHUkAgnfYUXfqjTm1AqgmoxB7SlQ10pS0EyJK+OU6mOc uT92Eh8qJecmFYPqs1oK4nEtJojJ9m0tbNVqHhTVcpkktt4gWCx41ioNS87dPvSALeWf N7jQ== X-Gm-Message-State: AOJu0YzVu6uIGaSUrtZiTynxbciL3SEn10aNjxXAvNb+BEGuJfcfUn6N 4q4TBqWWgfEVR/9ObaaiFAeV2dbU1VYX2GG4o2LbG3eUk2mDQaEaGUvPo5om/7gV2LJzQtxzkRX eIIM+q0DPEagbFdfhB2T7mw2X6vg= X-Gm-Gg: ASbGncs8PIZl0rj3havypIUVqflQqU0QvSLsYnu9Tk3NgGvzMUY5j6oS3loFmK1JnJa G96FsxAVx9tddLx6LnNnV5g1W6Vx5bY0GQ5Gv+zLJ6S/LEpjfV0eImXxcSUUjLlQb5YyPF1Y9AQ MXUaXf4wqCbYxjC+h5WLr1hWQLFHU/Zelchm/PrnUEElKUC/2MP+k0KpMkkUjn X-Google-Smtp-Source: AGHT+IF0Phu4lxMuxlBYr2sOtnUlGg2/bbYvwPrbmmh2Q6vOOYycqsPfR+iQ84s7F95S/QzIX33pKFueLF4mYhb1/r8= X-Received: by 2002:a05:6808:21a1:b0:3f6:78c3:55d1 with SMTP id 5614622812f47-3f697b48cc2mr3347448b6e.11.1741396968211; Fri, 07 Mar 2025 17:22:48 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Ron Johnson Date: Fri, 7 Mar 2025 20:22:37 -0500 X-Gm-Features: AQ5f1Jp6TD7XWyo_5iLA55mJVrr2c_PfQwQUN2De2Y3UZfvfdd8ckdDGdSUSQrU Message-ID: Subject: Re: No. Of wal files generated To: Atul Kumar Cc: pgsql-general Content-Type: multipart/alternative; boundary="000000000000b41123062fca93fa" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000b41123062fca93fa Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Fri, Mar 7, 2025 at 7:53=E2=80=AFPM Atul Kumar w= rote: > Please can you elaborate more about the meaning of inotifywait. > Google is your friend. > And how pgbackrest will solve the issue ? > PgBackRest does all the WAL archiving for you, keeps track of them, makes sure they are not overwritten, purges old ones when not needed etc. Even compresses and encrypts them if you want. > > > Regards. > > > > On Sat, 8 Mar 2025, 01:37 Ron Johnson, wrote: > >> inotifywait can log every file creation and deletion in a directory. >> >> Honestly, though, I'd strongly think about using PgBackRest instead of >> something you wrote yourself. >> >> On Fri, Mar 7, 2025 at 2:47=E2=80=AFPM Atul Kumar wrote: >> >>> I want to check and compare the speed wal file generation process and >>> archival process. >>> >>> So I want to check how many wal file got created in x minutes and how >>> many .ready files got created in those x minutes. >>> >>> >>> >>> Regards, >>> Atul >>> >>> On Fri, 7 Mar 2025, 22:45 Ron Johnson, wrote: >>> >>>> On Fri, Mar 7, 2025 at 10:59=E2=80=AFAM Atul Kumar >>>> wrote: >>>> >>>>> Hi, >>>>> >>>>> Please could you help me by sharing any redhat linux command through >>>>> which I can count the no. of wal files and no. of ".ready" files gene= rated >>>>> in last 10 minutes. >>>>> >>>> >>>> What problem are you trying to solve? >>>> >>>> -- >>>> Death to , and butter sauce. >>>> Don't boil me, I'm still alive. >>>> lobster! >>>> >>> >> >> -- >> Death to , and butter sauce. >> Don't boil me, I'm still alive. >> lobster! >> > --=20 Death to , and butter sauce. Don't boil me, I'm still alive. lobster! --000000000000b41123062fca93fa Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Fri, Mar 7, 2025 at 7:53=E2=80=AFPM At= ul Kumar <akumar14871@gmail.com= > wrote:
Please = can you elaborate more about the meaning of inotifywait.

Google is your friend.
=C2=A0
And how pgbackrest will solve the issue ?

PgBackRest does all the WAL archiving for you, keeps trac= k of them, makes sure they=C2=A0are not overwritten, purges old ones when= =C2=A0not needed etc.=C2=A0 Even compresses and encrypts them if you want.<= /div>
=C2=A0


Regards.=C2=A0



On Sat, 8 Mar 2025, 01:37 Ron Johnson, <ronljohnsonjr@gmail.com>= ; wrote:
inotifywait can log every file creation and deletion in a directo= ry.

Honestly, though, I'd strongly think about using= PgBackRest instead of something you wrote yourself.

On Fri, Mar 7, 20= 25 at 2:47=E2=80=AFPM Atul Kumar <akumar14871@gmail.com> wrote= :
I want to check and compare the speed=C2=A0 wal file generation process= and archival process.

So I wa= nt to check how many wal file got created in x minutes and how many .ready = files got created in those x minutes.=C2=A0



Regards,
Atul

On Fri, 7 Mar 2025, 22:45 Ron Jo= hnson, <ronljohnsonjr@gmail.com> wrote:
On= Fri, Mar 7, 2025 at 10:59=E2=80=AFAM Atul Kumar <akumar14= 871@gmail.com> wrote:
Hi,
=
Please could you help me by sharing any redhat = linux command through which I can count the no. of wal files and no. of &qu= ot;.ready" files generated in last 10 minutes.=C2=A0

What problem are you trying to solve?

--
Death to <Redacted= >, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!


--
Death to <Redacted>, and butter sauce.Don't boil me, I'm still alive.
<Redacted> lobs= ter!


--
Death to <Redacted>, and butter sauce.Don't boil me, I'm still alive.
<Redacted> lobs= ter!
--000000000000b41123062fca93fa--