pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
pg_autovacuum is not working
3+ messages / 2 participants
[nested] [flat]

* pg_autovacuum is not working
@ 2004-10-29 10:04 Ivan Dimitrov <dobber@bastun.net>
  2004-10-29 13:52 ` Re: pg_autovacuum is not working Christian Fowler <spider@viovio.com>
  2004-10-29 15:54 ` Re: pg_autovacuum is not working Ivan Dimitrov <dobber@bastun.net>
  0 siblings, 2 replies; 3+ messages in thread

From: Ivan Dimitrov @ 2004-10-29 10:04 UTC (permalink / raw)
  To: pgsql-admin

Hi list
This is my first post here, and I've searched google but couldn't find the 
solution.

I'm trying to run pg_autovacuum on all my databases. All my Debian sarge 
machines use version 7.4.5-3
postgresql                                      install
postgresql-client                               install
postgresql-contrib                              install
postgresql-dev                                  install
postgresql-doc                                  install

postgres.conf options are
stats_start_collector = true
stats_row_level = true

postmaster.conf options are
AUTOVACUUM=yes
AVAC_LOG=/var/log/postgresql/autovacuum_log

pg_hba.conf options are
local   all         postgres                   ident sameuser
local   all         all                               ident sameuser

restart postgresql gives this message in the logs:

autovacuum.log
[2004-10-29 12:41:20 PM] Error: GUC variable stats_row_level must be enabled.
[2004-10-29 12:41:20 PM]        Please fix the problems and try again.

postgres.log
2004-10-29 12:48:58 [29677] LOG:  unexpected EOF on client connection

What could be the reason for this. I have a test machine with the exact same 
options and databases as the production servers and it works find there. But 
on ~15 production servers I can't get rid of this message.
I can provide strace of pg_autovacuum, but I didn't find many usefull 
information in it.

Please advice
-- 


Hi! I'm your friendly neighbourhood signature virus.
Copy me to your signature file and help me spread!

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

* Re: pg_autovacuum is not working
  2004-10-29 10:04 pg_autovacuum is not working Ivan Dimitrov <dobber@bastun.net>
@ 2004-10-29 13:52 ` Christian Fowler <spider@viovio.com>
  1 sibling, 0 replies; 3+ messages in thread

From: Christian Fowler @ 2004-10-29 13:52 UTC (permalink / raw)
  To: Ivan Dimitrov <dobber@bastun.net>; +Cc: pgsql-admin


Hi Ivan,

I had the same experience as you. I swear I did all the things required. 
Eventually it started working with enough postmaster restarts and fiddling 
with the files. I'm sorry I can't be more helpful, cause I was never quite 
sure why it finally decided to start working...

Keep fiddling and it should hopefully start up.


On Fri, 29 Oct 2004, Ivan Dimitrov wrote:

> Hi list
> This is my first post here, and I've searched google but couldn't find the
> solution.
>
> I'm trying to run pg_autovacuum on all my databases. All my Debian sarge
> machines use version 7.4.5-3
>

[ \ /
[ >X<   Christian Fowler      | spider AT viovio.com
[ / \   http://www.viovio.com | http://www.tikipro.org



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

* Re: pg_autovacuum is not working
  2004-10-29 10:04 pg_autovacuum is not working Ivan Dimitrov <dobber@bastun.net>
@ 2004-10-29 15:54 ` Ivan Dimitrov <dobber@bastun.net>
  1 sibling, 0 replies; 3+ messages in thread

From: Ivan Dimitrov @ 2004-10-29 15:54 UTC (permalink / raw)
  To: pgsql-admin

The problem was in my resolve.conf, the nameserver I've set is my datacenter 
provider who have localhost.provider.net point to 127.0.0.1 and postmaster 
couldn't bind to that host. For whatever reason. It does not check /etc/hosts 
too so I'll play with it on Mondey.

На 29.10.2004 18:20 вие написахте:
> Ivan Dimitrov <dobber@bastun.net> writes:
> > autovacuum.log
> > [2004-10-29 12:41:20 PM] Error: GUC variable stats_row_level must be
> > enabled. [2004-10-29 12:41:20 PM]        Please fix the problems and try
> > again.
> >
> > What could be the reason for this.
>
> I'd say autovacuum is being perfectly clear what it's not happy about.
>
> Are you sure you are editing the right copy of postgresql.conf?  I seem
> to recall that the Debian distribution patches the PG code to look for
> that file in (what we consider) a nonstandard place.
>
>    regards, tom lane

-- 


Hi! I'm your friendly neighbourhood signature virus.
Copy me to your signature file and help me spread!

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


end of thread, other threads:[~2004-10-29 15:54 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-10-29 10:04 pg_autovacuum is not working Ivan Dimitrov <dobber@bastun.net>
2004-10-29 13:52 ` Christian Fowler <spider@viovio.com>
2004-10-29 15:54 ` Ivan Dimitrov <dobber@bastun.net>

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