pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
pg_autovacuum ?
7+ messages / 7 participants
[nested] [flat]

* pg_autovacuum ?
@ 2003-08-04 14:15 Mendola Gaetano <mendola@bigfoot.com>
  2003-08-12 14:46 ` Re: pg_autovacuum ? Robert Treat <xzilla@users.sourceforge.net>
  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-04 14:15 pg_autovacuum ? Mendola Gaetano <mendola@bigfoot.com>
@ 2003-08-12 14:46 ` Robert Treat <xzilla@users.sourceforge.net>
  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
  2004-09-23 07:52 ` Re: pg_autovacuum Cris Carampa <cris119@operamail.com>
  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-22 14:08 pg_autovacuum iulia.pacurar@base.ro
@ 2004-09-23 07:52 ` Cris Carampa <cris119@operamail.com>
  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>
  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>
  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 10:11 pg_autovacuum Eran L <eranlz@gmail.com>
@ 2006-01-11 15:03 ` Tom Lane <tgl@sss.pgh.pa.us>
  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 10:11 pg_autovacuum Eran L <eranlz@gmail.com>
@ 2006-01-11 15:08 ` Jaime Casanova <systemguards@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