Re: Log retention query - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Log retention query
Date
Msg-id 5ad33e59-a786-407c-ac03-98d248f0edac@aklaver.com
Whole thread Raw
In response to Re: Log retention query  (Paul Brindusa <paulbrindusa88@gmail.com>)
List pgsql-general
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




pgsql-general by date:

Previous
From: Paul Brindusa
Date:
Subject: Re: Log retention query
Next
From: Marcelo Fernandes
Date:
Subject: Logging queries executed by SPI_execute