pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpg_autovacuum ?
7+ messages / 7 participants
[nested] [flat]
* pg_autovacuum ?
@ 2003-08-04 14:15 Mendola Gaetano <mendola@bigfoot.com>
0 siblings, 1 reply; 7+ messages in thread
From: Mendola Gaetano @ 2003-08-04 14:15 UTC (permalink / raw)
To: pgsql-admin
Hi,
I used to install postgres 7.3.3 from RPM,
today I needed to take a look at pg_utovacuum but I didn't
find it ?
Should I download it somewhere else ?
Regards
Gaetano Mendola
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: pg_autovacuum ?
@ 2003-08-12 14:46 Robert Treat <xzilla@users.sourceforge.net>
parent: Mendola Gaetano <mendola@bigfoot.com>
0 siblings, 0 replies; 7+ messages in thread
From: Robert Treat @ 2003-08-12 14:46 UTC (permalink / raw)
To: Mendola Gaetano <mendola@bigfoot.com>; +Cc: pgsql-admin
On Mon, 2003-08-04 at 10:15, Mendola Gaetano wrote:
> Hi,
> I used to install postgres 7.3.3 from RPM,
> today I needed to take a look at pg_utovacuum but I didn't
> find it ?
>
> Should I download it somewhere else ?
>
you'd have to check it out from CVS and then compile it into a 7.3 cvs
pull. It's on the 7.4 branch, not on the 7.3 branch, but the authors
mentioned that at least initially it would run against 7.3.
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
^ permalink raw reply [nested|flat] 7+ messages in thread
* pg_autovacuum
@ 2004-09-22 14:08 iulia.pacurar@base.ro
0 siblings, 1 reply; 7+ messages in thread
From: iulia.pacurar@base.ro @ 2004-09-22 14:08 UTC (permalink / raw)
To: pgsql-admin
Hi!
I run pg_autovacuum:
./pg_autovacuum -D
but then I cannot find pg_autovacuum.log file.
Where shoud I look for it?
Thank you.
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: pg_autovacuum
@ 2004-09-23 07:52 Cris Carampa <cris119@operamail.com>
parent: iulia.pacurar@base.ro
0 siblings, 0 replies; 7+ messages in thread
From: Cris Carampa @ 2004-09-23 07:52 UTC (permalink / raw)
To: pgsql-admin
iulia.pacurar@base.ro wrote:
> I run pg_autovacuum:
> ./pg_autovacuum -D
> but then I cannot find pg_autovacuum.log file.
> Where shoud I look for it?
Try:
./pg_autovacuum -D -L <logfile>
Kind regards,
--
Cris Carampa (spamto:cris119@operamail.com)
I got some John Coltrane on the stereo baby make it feel all right
I got some fine wine in the freezer mama I know what you like
I said a man works hard all day he can do what he wants to at night
^ permalink raw reply [nested|flat] 7+ messages in thread
* pg_autovacuum
@ 2006-01-11 10:11 Eran L <eranlz@gmail.com>
0 siblings, 2 replies; 7+ messages in thread
From: Eran L @ 2006-01-11 10:11 UTC (permalink / raw)
To: pgsql-admin
Hi,
I must be missing some obvious and trivial thing, since I simply can
get pg_autovacuum to work.
Im working on FC4, postgresql 8.0.6.
In the "postgresql.conf" file, I've set:
stats_row_level = true
I've restarted the postmaster. Yet, when I'm running pg_autovacuum, it says:
[2006-01-11 12:11:07 IST] ERROR: GUC variable stats_row_level must be enabled.
[2006-01-11 12:11:07 IST] Please fix the problems and try again.
What more needs to be done ?
TIA,
Eran
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: pg_autovacuum
@ 2006-01-11 15:03 Tom Lane <tgl@sss.pgh.pa.us>
parent: Eran L <eranlz@gmail.com>
1 sibling, 0 replies; 7+ messages in thread
From: Tom Lane @ 2006-01-11 15:03 UTC (permalink / raw)
To: Eran L <eranlz@gmail.com>; +Cc: pgsql-admin
Eran L <eranlz@gmail.com> writes:
> Im working on FC4, postgresql 8.0.6.
> In the "postgresql.conf" file, I've set:
> stats_row_level = true
> I've restarted the postmaster. Yet, when I'm running pg_autovacuum, it says:
> [2006-01-11 12:11:07 IST] ERROR: GUC variable stats_row_level must be enabled.
> [2006-01-11 12:11:07 IST] Please fix the problems and try again.
Does "SHOW stats_row_level" agree that it's not on? If so, maybe you
forgot stats_start_collector.
regards, tom lane
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: pg_autovacuum
@ 2006-01-11 15:08 Jaime Casanova <systemguards@gmail.com>
parent: Eran L <eranlz@gmail.com>
1 sibling, 0 replies; 7+ messages in thread
From: Jaime Casanova @ 2006-01-11 15:08 UTC (permalink / raw)
To: Eran L <eranlz@gmail.com>; +Cc: pgsql-admin
On 1/11/06, Eran L <eranlz@gmail.com> wrote:
> Hi,
>
> I must be missing some obvious and trivial thing, since I simply can
> get pg_autovacuum to work.
>
> Im working on FC4, postgresql 8.0.6.
> In the "postgresql.conf" file, I've set:
>
> stats_row_level = true
>
> I've restarted the postmaster. Yet, when I'm running pg_autovacuum, it says:
>
> [2006-01-11 12:11:07 IST] ERROR: GUC variable stats_row_level must be enabled.
> [2006-01-11 12:11:07 IST] Please fix the problems and try again.
>
> What more needs to be done ?
>
> TIA,
> Eran
>
i guess you remove the # symbol in front of that line
--
Atentamente,
Jaime Casanova
(DBA: DataBase Aniquilator ;)
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2006-01-11 15:08 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-08-04 14:15 pg_autovacuum ? Mendola Gaetano <mendola@bigfoot.com>
2003-08-12 14:46 ` Robert Treat <xzilla@users.sourceforge.net>
2004-09-22 14:08 pg_autovacuum iulia.pacurar@base.ro
2004-09-23 07:52 ` Re: pg_autovacuum Cris Carampa <cris119@operamail.com>
2006-01-11 10:11 pg_autovacuum Eran L <eranlz@gmail.com>
2006-01-11 15:03 ` Re: pg_autovacuum Tom Lane <tgl@sss.pgh.pa.us>
2006-01-11 15:08 ` Re: pg_autovacuum Jaime Casanova <systemguards@gmail.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