On Thu, 2008-02-21 at 22:47 +0000, Christopher Browne wrote:
> Ow Mun Heng <Ow.Mun.Heng at wdc.com> writes:
> > On Thu, 2008-02-21 at 18:47 +0000, Christopher Browne wrote:

> > Chris(you) already shown me how to manually force a logswitch, and thus,
> > now I'm considering making a job to manually force the switch like every
> > 6 hours just to get the size under control. Is this a good Idea?
> 
> You can automate that by, um, ...  Hey, that's not well enough
> documented :-).

No wonder I'm confused ;-)

> 
> The default, as controlled by data in sl_registry, is to switch logs
> once per week.
> 
> Actually, looking at the code, the way it accesses sl_registry,
> there's not a straightforward way to change that to either daily or
> multiple times per day.  I think for CVS HEAD, I'm inclined to clean
> that stuff out because there is a cleaner way, using the new parameter,
> cleanup_interval.
> 
> For now, I think that running a script that starts the log switch
> every 6 hours is probably about the right idea.

Okie. Thanks for the pointer. I will do that via pgagent