Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tehbN-00F80M-JS for pgsql-general@arkaria.postgresql.org; Sun, 02 Feb 2025 21:34:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tehbM-008Vdg-7b for pgsql-general@arkaria.postgresql.org; Sun, 02 Feb 2025 21:34:00 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tehbL-008VdV-1O for pgsql-general@lists.postgresql.org; Sun, 02 Feb 2025 21:33:59 +0000 Received: from fhigh-b6-smtp.messagingengine.com ([202.12.124.157]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tehbG-002vUd-2m for pgsql-general@lists.postgresql.org; Sun, 02 Feb 2025 21:33:58 +0000 Received: from phl-compute-11.internal (phl-compute-11.phl.internal [10.202.2.51]) by mailfhigh.stl.internal (Postfix) with ESMTP id A1AC7254013A; Sun, 2 Feb 2025 16:33:52 -0500 (EST) Received: from phl-mailfrontend-01 ([10.202.2.162]) by phl-compute-11.internal (MEProxy); Sun, 02 Feb 2025 16:33:52 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:content-transfer-encoding:content-type:content-type:date:date :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to; s=fm2; t=1738532032; x=1738618432; bh=p2r0caoMoaRCqGTksZmyii1hPTkHrQzFgylh/fTkGsg=; b= iKDUDjfRPx+etN3sAZsRGEC+07HU4HjZSXV8lcSnjGLFgJAPAoiGfMnfHhe10SMg AlAMcqicobuzz7q08zjVDJsPM4FFYHrYQyPeZTBH9lCXXtzfEWQxrukeF6YrJMgD +zZWqJxYe3uTtp2M9qbYy0gMrC5WC+nAklN2510RAyQFSigiHcOvN2c3Pt++++TT FDp6nTYMwq2Y8sCW9d4umZGl2SleNK2j8/qF/PvIW5ZWBdHhdqyAE6KhdEdtcOAC VtGIHeH1zNGXM13wtigq0soPEpok8bW7DTJI0LLd4i8YhvNjHZDcPvBTgAWbbdwA VUkIQWY2fa1RhGNT+Ck21g== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :content-type:date:date:feedback-id:feedback-id:from:from :in-reply-to:in-reply-to:message-id:mime-version:references :reply-to:subject:subject:to:to:x-me-proxy:x-me-sender :x-me-sender:x-sasl-enc; s=fm3; t=1738532032; x=1738618432; bh=p 2r0caoMoaRCqGTksZmyii1hPTkHrQzFgylh/fTkGsg=; b=KTQ8tUuMCDqQhJqwI RQE6XU4qHqhIytaBzJLMpE7TNGgkQHqcVRWlAs9V4zuIA97nOagRxx5TmC/fsDJ9 qqeXSyTWc2XdrNxYx2gREEYrND+jebDDeutCXbHvVJIRRPFLMAiLAh8oe8SjuaeP hrE30pTVxXNuk/rtkM1vIfUbRu2U1FzblqHV5pFhZWEGuNF2GDHcNk/471QtnPxF XVnKimhGDvFlDejz12Hai6Lxo1SQjlkeUUMByq3TD5EnlQ81AkmKCb/w3g+9zbip qr4EvAQhgbofBluJ6IvowOgMY/RXfh1jUPrjYsJYdC69g049kF9I7JV7+ix5Cqak rjxEw== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefvddrtddtgdduheejjecutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpggftfghnshhusghstghrihgsvgdp uffrtefokffrpgfnqfghnecuuegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivg hnthhsucdlqddutddtmdenucfjughrpefkffggfgfuvfhfhfgjtgfgsehtkeertddtvdej necuhfhrohhmpeetughrihgrnhcumfhlrghvvghruceorggurhhirghnrdhklhgrvhgvrh esrghklhgrvhgvrhdrtghomheqnecuggftrfgrthhtvghrnhepffelgeeifefgveduhedt hfekuedtffejveegffegjeevtdehgfduieetfeehjeehnecuvehluhhsthgvrhfuihiivg eptdenucfrrghrrghmpehmrghilhhfrhhomheprggurhhirghnrdhklhgrvhgvrhesrghk lhgrvhgvrhdrtghomhdpnhgspghrtghpthhtohepvddpmhhouggvpehsmhhtphhouhhtpd hrtghpthhtohepphgruhhlsghrihhnughushgrkeeksehgmhgrihhlrdgtohhmpdhrtghp thhtohepphhgshhqlhdqghgvnhgvrhgrlheslhhishhtshdrphhoshhtghhrvghsqhhlrd horhhg X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Sun, 2 Feb 2025 16:33:51 -0500 (EST) Message-ID: <5ad33e59-a786-407c-ac03-98d248f0edac@aklaver.com> Date: Sun, 2 Feb 2025 13:33:51 -0800 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Log retention query To: Paul Brindusa , pgsql-general@lists.postgresql.org References: <20250202082618.trv7vpxw3stkqqw4@hjp.at> <20250202195713.do65y2ewc6vjk3r5@hjp.at> <147245a5-5105-4cf1-85cf-bb92176b9702@gmail.com> Content-Language: en-US From: Adrian Klaver In-Reply-To: <147245a5-5105-4cf1-85cf-bb92176b9702@gmail.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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