| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Paul Brindusa <paulbrindusa88(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Log retention query |
| Date: | 2025-02-02 21:33:51 |
| Message-ID: | 5ad33e59-a786-407c-ac03-98d248f0edac@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2025-02-02 21:56:59 | Re: Using Expanded Objects other than Arrays from plpgsql |
| Previous Message | Paul Brindusa | 2025-02-02 20:04:09 | Re: Log retention query |