public inbox for [email protected]  

help / color / mirror / Atom feed

From: Adrian Klaver <[email protected]>
To: Paul Brindusa <[email protected]>
To: Laurenz Albe <[email protected]>
Cc: pgsql-general <[email protected]>
Subject: Re: Log retention query
Date: Tue, 28 Jan 2025 08:16:25 -0800
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAFeSbqjqi1DZjQDatiZehk3GpkX_dFv=qgfsgWxKbsACSWJv_g@mail.gmail.com>
References: <CAFeSbqjnRXNZ72NdD+G6ScKKBTQXAxpMk=XyH1sPGs+L2atF_A@mail.gmail.com>
	<[email protected]>
	<CAFeSbqjqi1DZjQDatiZehk3GpkX_dFv=qgfsgWxKbsACSWJv_g@mail.gmail.com>

On 1/28/25 05:40, Paul Brindusa wrote:
> @Junwang apologies, I should have mentioned that  we've tried setting up 
> a crontab and it has not worked. Have you got something similar working?
> 
> @Laurenz: log_filename: postgresql-%Y-%m-%d.log  -- if we redo the 
> syntax can we make it trigger garbage collection on 180 days?

If by garbage collection you mean 'log_truncate_on_rotation: on' then 
you would need some pattern that would repeat after 180 days. Off the 
top of my head I cannot come up with one that would do that.

How did you install Postgres and on what platform?


> -- 
> Kind Regards,
> Paul Brindusa
> [email protected] <mailto:[email protected]>
> 

-- 
Adrian Klaver
[email protected]

view thread (13+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Log retention query
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox