pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpg_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>
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 13:52 Christian Fowler <spider@viovio.com>
parent: Ivan Dimitrov <dobber@bastun.net>
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 15:54 Ivan Dimitrov <dobber@bastun.net>
parent: 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