From: | Ron Johnson <ronljohnsonjr(at)gmail(dot)com> |
---|---|
To: | Atul Kumar <akumar14871(at)gmail(dot)com> |
Cc: | pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: No. Of wal files generated |
Date: | 2025-03-08 01:22:37 |
Message-ID: | CANzqJaCH1U_3vihBm5wUZhtrXCXwM4GxcdkcpojUTLOtE49PTg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, Mar 7, 2025 at 7:53 PM Atul Kumar <akumar14871(at)gmail(dot)com> 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, <ronljohnsonjr(at)gmail(dot)com> 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 <akumar14871(at)gmail(dot)com> 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, <ronljohnsonjr(at)gmail(dot)com> wrote:
>>>
>>>> On Fri, Mar 7, 2025 at 10:59 AM Atul Kumar <akumar14871(at)gmail(dot)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 ".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!
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Sabino Mullane | 2025-03-08 03:34:22 | Re: No. Of wal files generated |
Previous Message | Atul Kumar | 2025-03-08 00:53:25 | Re: No. Of wal files generated |