Re: Log retention query - Mailing list pgsql-general

From Paul Brindusa
Subject Re: Log retention query
Date
Msg-id CAFeSbqh_+CSC0Ot98ML_O=ybd3AJRUbfREAUAC2KOsG6bhNdgg@mail.gmail.com
Whole thread Raw
In response to Log retention query  (Paul Brindusa <paulbrindusa88@gmail.com>)
List pgsql-general
Good afternoon,

Apologies for coming back to you so late.

Again I want to thank everyone for all the help provided regarding this. The main culprit was the cron job and trying to run it as root.
Main thing is i've learned a lot from your answers about the logs.
Thank you again.


On Sun, Feb 2, 2025 at 9:33 PM Adrian Klaver <adrian.klaver@aklaver.com> wrote:
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



--
Kind Regards,
Paul Brindusa

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Any plan for minor release?
Next
From: Rich Shepard
Date:
Subject: psql command line editing