Hi,

What's the best way to do log rolling with pg_autovacuum?  It doesn't 
seem to have any syslog options, etc.  Using 'tee' maybe?

Chris


Fri, 16 Jan 2004 12:17:33 +0800
Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Log rotation for pg_autovacuum
Christopher Kings-Lynne wrote:

> What's the best way to do log rolling with pg_autovacuum?  It doesn't 
> seem to have any syslog options, etc.  Using 'tee' maybe?


I got an email from Mark Hollow saying that he had implemented a syslog 
patch for pg_autovacuum.  Don't know how good it is, but it might be a 
start.

Mark can you post it to the list?

Matthew

Thu, 15 Jan 2004 23:32:24 -0500
"Matthew T. O'Connor" <matthew@zeut.net>
Re: Log rotation for pg_autovacuum
Seems posting to this list from the office didn't work...

The patch is attached as requested - this is just a quick hack, written to
do what I needed at the time.. consider it just as a starting point for
further work.

I've tested it on Solaris 9 with Sun's compiler (Sun Studio 8 Compilers)
but unfortunately don't have the time or facilities for more extensive
tests on other OS's.

Cheers,
Mark

On Thu, 15 Jan 2004, Matthew T. O'Connor wrote:

> Christopher Kings-Lynne wrote:
> 
> > What's the best way to do log rolling with pg_autovacuum?  It doesn't 
> > seem to have any syslog options, etc.  Using 'tee' maybe?
> 
> 
> I got an email from Mark Hollow saying that he had implemented a syslog 
> patch for pg_autovacuum.  Don't know how good it is, but it might be a 
> start.
> 
> Mark can you post it to the list?
> 
> Matthew
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
>       joining column's datatypes do not match
>
Mon, 26 Jan 2004 22:26:39 +0000 (GMT)
Mark Hollow <mark@markhollow.com>
Re: Log rotation for pg_autovacuum