pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpg_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>
2005-12-12 00:07 ` Re: pg_autovacuum log size in postgres v8.0 Matthew T. O'Connor <matthew@zeut.net>
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-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 ` Re: pg_autovacuum log size in postgres v8.0 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-10 22:42 pg_autovacuum log size in postgres v8.0 Ameet Kini <akini@cs.wisc.edu>
2005-12-12 00:07 ` Re: pg_autovacuum log size in postgres v8.0 Matthew T. O'Connor <matthew@zeut.net>
@ 2005-12-13 02:01 ` Ameet Kini <akini@cs.wisc.edu>
2005-12-13 02:14 ` Re: pg_autovacuum log size in postgres v8.0 Jeff Frost <jeff@frostconsultingllc.com>
2005-12-13 02:19 ` Re: pg_autovacuum log size in postgres v8.0 Alvaro Herrera <alvherre@commandprompt.com>
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-10 22:42 pg_autovacuum log size in postgres v8.0 Ameet Kini <akini@cs.wisc.edu>
2005-12-12 00:07 ` Re: pg_autovacuum log size in postgres v8.0 Matthew T. O'Connor <matthew@zeut.net>
2005-12-13 02:01 ` Re: pg_autovacuum log size in postgres v8.0 Ameet Kini <akini@cs.wisc.edu>
@ 2005-12-13 02:14 ` Jeff Frost <jeff@frostconsultingllc.com>
2005-12-13 13:22 ` Re: pg_autovacuum log size in postgres v8.0 Matthew T. O'Connor <matthew@tocr.com>
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-10 22:42 pg_autovacuum log size in postgres v8.0 Ameet Kini <akini@cs.wisc.edu>
2005-12-12 00:07 ` Re: pg_autovacuum log size in postgres v8.0 Matthew T. O'Connor <matthew@zeut.net>
2005-12-13 02:01 ` Re: pg_autovacuum log size in postgres v8.0 Ameet Kini <akini@cs.wisc.edu>
2005-12-13 02:14 ` Re: pg_autovacuum log size in postgres v8.0 Jeff Frost <jeff@frostconsultingllc.com>
@ 2005-12-13 13:22 ` Matthew T. O'Connor <matthew@tocr.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
* Re: pg_autovacuum log size in postgres v8.0
2005-12-10 22:42 pg_autovacuum log size in postgres v8.0 Ameet Kini <akini@cs.wisc.edu>
2005-12-12 00:07 ` Re: pg_autovacuum log size in postgres v8.0 Matthew T. O'Connor <matthew@zeut.net>
2005-12-13 02:01 ` Re: pg_autovacuum log size in postgres v8.0 Ameet Kini <akini@cs.wisc.edu>
@ 2005-12-13 02:19 ` Alvaro Herrera <alvherre@commandprompt.com>
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
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