pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
pg_autovacuum log size in postgres v8.0
6+ messages / 5 participants
[nested] [flat]

* pg_autovacuum log size in postgres v8.0
@ 2005-12-10 22:42  Ameet Kini <akini@cs.wisc.edu>
  0 siblings, 1 reply; 6+ messages in thread

From: Ameet Kini @ 2005-12-10 22:42 UTC (permalink / raw)
  To: pgsql-admin



Hello,

I'm using postgresql 8.0 and am using contrib/pg_autovacuum. Is there a
way to tell pg_autovacuum to rotate the log that it generates after
it reaches a particular size? From the set of command line options, it
seems that its only possible to specify the location of the logfile (via
the -L option) but not its size.

Thanks,
Ameet



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: pg_autovacuum log size in postgres v8.0
@ 2005-12-12 00:07  Matthew T. O'Connor <matthew@zeut.net>
  parent: Ameet Kini <akini@cs.wisc.edu>
  0 siblings, 1 reply; 6+ messages in thread

From: Matthew T. O'Connor @ 2005-12-12 00:07 UTC (permalink / raw)
  To: Ameet Kini <akini@cs.wisc.edu>; +Cc: pgsql-admin

Unfortunately, you are correct, there is no way to tell 
contrib/autovacuum to rotate it's logs.

Ameet Kini wrote:
> Hello,
>
> I'm using postgresql 8.0 and am using contrib/pg_autovacuum. Is there a
> way to tell pg_autovacuum to rotate the log that it generates after
> it reaches a particular size? From the set of command line options, it
> seems that its only possible to specify the location of the logfile (via
> the -L option) but not its size.
>
> Thanks,
> Ameet
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo@postgresql.org so that your
>        message can get through to the mailing list cleanly
>
>   




^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: pg_autovacuum log size in postgres v8.0
@ 2005-12-13 02:01  Ameet Kini <akini@cs.wisc.edu>
  parent: Matthew T. O'Connor <matthew@zeut.net>
  0 siblings, 2 replies; 6+ messages in thread

From: Ameet Kini @ 2005-12-13 02:01 UTC (permalink / raw)
  To: pgsql-admin




Any plans of incorporating it into a future release? How do people
currently deal with this problem? I wonder if this is fixed in the
pg_autovacuum distributed with v8.1

On Sun, 11 Dec 2005, Matthew T. O'Connor wrote:

> Unfortunately, you are correct, there is no way to tell
> contrib/autovacuum to rotate it's logs.
>
> Ameet Kini wrote:
> > Hello,
> >
> > I'm using postgresql 8.0 and am using contrib/pg_autovacuum. Is there a
> > way to tell pg_autovacuum to rotate the log that it generates after
> > it reaches a particular size? From the set of command line options, it
> > seems that its only possible to specify the location of the logfile (via
> > the -L option) but not its size.
> >
> > Thanks,
> > Ameet
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 1: if posting/reading through Usenet, please send an appropriate
> >        subscribe-nomail command to majordomo@postgresql.org so that your
> >        message can get through to the mailing list cleanly
> >
> >
>

Ameet



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: pg_autovacuum log size in postgres v8.0
@ 2005-12-13 02:14  Jeff Frost <jeff@frostconsultingllc.com>
  parent: Ameet Kini <akini@cs.wisc.edu>
  1 sibling, 1 reply; 6+ messages in thread

From: Jeff Frost @ 2005-12-13 02:14 UTC (permalink / raw)
  To: Ameet Kini <akini@cs.wisc.edu>; +Cc: pgsql-admin

Most people running Linux would add it to their logrotate.conf or other log 
management methods.


On Mon, 12 Dec 2005, Ameet Kini wrote:

>
> Any plans of incorporating it into a future release? How do people
> currently deal with this problem? I wonder if this is fixed in the
> pg_autovacuum distributed with v8.1
>

-- 
Jeff Frost, Owner 	<jeff@frostconsultingllc.com>
Frost Consulting, LLC 	http://www.frostconsultingllc.com/
Phone: 650-780-7908	FAX: 650-649-1954



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: pg_autovacuum log size in postgres v8.0
@ 2005-12-13 02:19  Alvaro Herrera <alvherre@commandprompt.com>
  parent: Ameet Kini <akini@cs.wisc.edu>
  1 sibling, 0 replies; 6+ messages in thread

From: Alvaro Herrera @ 2005-12-13 02:19 UTC (permalink / raw)
  To: Ameet Kini <akini@cs.wisc.edu>; +Cc: pgsql-admin

Ameet Kini wrote:
> 
> Any plans of incorporating it into a future release? How do people
> currently deal with this problem? I wonder if this is fixed in the
> pg_autovacuum distributed with v8.1

8.1 does not have this problem, because autovacuum got integrated into
the server proper and no longer has a separate log.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: pg_autovacuum log size in postgres v8.0
@ 2005-12-13 13:22  Matthew T. O'Connor <matthew@tocr.com>
  parent: Jeff Frost <jeff@frostconsultingllc.com>
  0 siblings, 0 replies; 6+ messages in thread

From: Matthew T. O'Connor @ 2005-12-13 13:22 UTC (permalink / raw)
  To: Jeff Frost <jeff@frostconsultingllc.com>; +Cc: Ameet Kini <akini@cs.wisc.edu>; pgsql-admin

As Alvaro already mentioned this is fixed in 8.1 because it was 
integrated into the backend and benifits from the logging features that 
backend already has developed.

As for the 7.4.x & 8.0.x versions of contrib autovacuum, I don't think 
there are any plans for improving it.  Also, added it to your logrotate 
would probably be a bad idea as it has no code to reopen it's log files 
on SIGHUP nor is killing and restarting the autovacuum process a good 
idea as contrib/autovacuum loses track of activity when it restarts.

Matt



Jeff Frost wrote:
> Most people running Linux would add it to their logrotate.conf or 
> other log management methods.
>
>
> On Mon, 12 Dec 2005, Ameet Kini wrote:
>
>>
>> Any plans of incorporating it into a future release? How do people
>> currently deal with this problem? I wonder if this is fixed in the
>> pg_autovacuum distributed with v8.1
>>
>




^ permalink  raw  reply  [nested|flat] 6+ messages in thread


end of thread, other threads:[~2005-12-13 13:22 UTC | newest]

Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-12-10 22:42 pg_autovacuum log size in postgres v8.0 Ameet Kini <akini@cs.wisc.edu>
2005-12-12 00:07 ` Matthew T. O'Connor <matthew@zeut.net>
2005-12-13 02:01   ` Ameet Kini <akini@cs.wisc.edu>
2005-12-13 02:14     ` Jeff Frost <jeff@frostconsultingllc.com>
2005-12-13 13:22       ` Matthew T. O'Connor <matthew@tocr.com>
2005-12-13 02:19     ` Alvaro Herrera <alvherre@commandprompt.com>

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