Re: No. Of wal files generated

2025-03-10 Thread Achilleas Mantzios - cloud
On 3/7/25 17:59, 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 generated in last 10 minutes. Do you have wal archiving enabled? If yes, then simply go to the archive dir and suit y

Re: No. Of wal files generated

2025-03-07 Thread Greg Sabino Mullane
Take a look at the pg_stat_archiver view, if you have not already: https://www.postgresql.org/docs/current/monitoring-stats.html#MONITORING-PG-STAT-ARCHIVER-VIEW 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. > It's not c

Re: No. Of wal files generated

2025-03-07 Thread Ron Johnson
On Fri, Mar 7, 2025 at 7:53 PM Atul Kumar 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, pu

Re: No. Of wal files generated

2025-03-07 Thread Atul Kumar
Please can you elaborate more about the meaning of inotifywait. And how pgbackrest will solve the issue ? 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 PgBack

Re: No. Of wal files generated

2025-03-07 Thread Atul Kumar
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 a

Re: No. Of wal files generated

2025-03-07 Thread Ron Johnson
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 wrote: > I want to check and compare the speed wal file generation process and > a

Re: No. Of wal files generated

2025-03-07 Thread Ron Johnson
On Fri, Mar 7, 2025 at 10:59 AM 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 generated in > last 10 minutes. > What problem are you trying to solve? -- Death to , and butter s

No. Of wal files generated

2025-03-07 Thread Atul Kumar
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. Regards, Atul