Re: Log retention query

On 2/2/25 12:04, Paul Brindusa wrote:
> I am defo sure that my syntax was fine.
> 
> I have tried the same syntax to remove the logs manually from the 
> folder  and it worked perfectly.
> 
> The cronjob was set from root, so I am assuming it has the right 
> privileges over the folder in cause.
> 

Did you use the correct directory in the cron command?

> 
> @ Adrian the cluster runs on Rocky9

What repo are you using to install Postgres from?

> 
> There is no error from cron that is the weird bit as well.
> 
> I do not have MAILTO set up on cron.

I would do that, then you should get the errors.

You could also look in the system log at the time the cron job was 
executed to see if it recorded the error.

> 
> Regards,
> 
> Paul
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com