public inbox for [email protected]
help / color / mirror / Atom feedFrom: Ron Johnson <[email protected]>
To: Atul Kumar <[email protected]>
Cc: pgsql-general <[email protected]>
Subject: Re: No. Of wal files generated
Date: Fri, 7 Mar 2025 20:22:37 -0500
Message-ID: <CANzqJaCH1U_3vihBm5wUZhtrXCXwM4GxcdkcpojUTLOtE49PTg@mail.gmail.com> (raw)
In-Reply-To: <CA+ONtZ6=St+GxmtE5MYarqdUSG3EHrXtUKe2ztgcsvMVeTUQOQ@mail.gmail.com>
References: <CA+ONtZ4q9OkEHx0pCf87Z876=_vM7=+Ko18HF8+WHrENQ8mxLg@mail.gmail.com>
<CANzqJaB4Qz2iqvaprSHH18=A3neAMBugJ4OLoZr2UZ3rQiUF2A@mail.gmail.com>
<CA+ONtZ6q4+wcNH9dPZm2tugLaU98xrf7iU8UA6JC2NVYtW_JRw@mail.gmail.com>
<CANzqJaAkTrMobswbupC=6XYaex47iwC6rz4WpaK=HSbZZMpcxQ@mail.gmail.com>
<CA+ONtZ6=St+GxmtE5MYarqdUSG3EHrXtUKe2ztgcsvMVeTUQOQ@mail.gmail.com>
On Fri, Mar 7, 2025 at 7:53 PM Atul Kumar <[email protected]> wrote:
> 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, <[email protected]> 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 PM Atul Kumar <[email protected]> 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, <[email protected]> wrote:
>>>
>>>> On Fri, Mar 7, 2025 at 10:59 AM Atul Kumar <[email protected]>
>>>> 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 generated
>>>>> in last 10 minutes.
>>>>>
>>>>
>>>> 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> lobster!
>>
>
--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: No. Of wal files generated
In-Reply-To: <CANzqJaCH1U_3vihBm5wUZhtrXCXwM4GxcdkcpojUTLOtE49PTg@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox