On Wed 21 Sep 2005, Debian Bug Tracking System wrote:
>
> I'm 98% sure that you forgot to install postgresql-contrib. That
> package ships pg_autovacuum. After installing it, the daemon should
> be started automatically.
I finally had a time window to install it:
...
Selecting previously deselected package libpg-perl.
(Reading database ... 18024 files and directories currently installed.)
Unpacking libpg-perl (from .../libpg-perl_1%3a2.0.2-4_i386.deb) ...
Selecting previously deselected package postgresql-contrib.
Unpacking postgresql-contrib (from
.../postgresql-contrib_7.4.7-6sarge1_i386.deb) ...
Setting up libpg-perl (2.0.2-4) ...
Setting up postgresql-contrib (7.4.7-6sarge1) ...
autovacuum started
Reading Package Lists... Done
Building Dependency Tree
Reading extended state information
Initializing package states... Done
[EMAIL PROTECTED]:~$ ps -fe | grep auto
paul 8087 7439 0 01:06 pts/1 00:00:00 grep auto
[EMAIL PROTECTED]:~$ sudo sh -x /etc/init.d/postgresql autovac-start
+ export
PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/X11R6/bin:/sbin:/usr/sbin:/bin:/usr/bin
+
PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/X11R6/bin:/sbin:/usr/sbin:/bin:/usr/bin
+ PREFIX=/usr/lib/postgresql
+ POSTMASTER=/usr/lib/postgresql/bin/postmaster
+ PG_CTL=/usr/lib/postgresql/bin/pg_ctl
+ PG_AUTOVACUUM=/usr/lib/postgresql/bin/pg_autovacuum
+ PG_STARTUP=/usr/lib/postgresql/bin/postgresql-startup
++ grep -si '^port *=' /etc/postgresql/postgresql.conf
++ cut -f2 -d=
+ PGPORT=
+ '[' '!' 0 -eq 0 ']'
+ '[' -x /usr/lib/postgresql/bin/postmaster ']'
+ '[' -r /etc/postgresql/postmaster.conf ']'
+ . /etc/postgresql/postmaster.conf
+++ getent passwd postgres
+++ awk -F: '{print $6}'
+++ head -1
++ POSTGRES_HOME=/var/lib/postgres
++ '[' -z /var/lib/postgres ']'
++ POSTMASTER_OPTIONS=
++ AUTOVACUUM=yes
+ PGDATA=/var/lib/postgres/data
+ export PGDATA
+ '[' -f /var/lib/postgres/data/autovacuum.pid ']'
+ echo pg_autovacuum is already running
pg_autovacuum is already running
+ exit 0
[EMAIL PROTECTED]:~$ cat /var/lib/postgres/data/autovacuum.pid
cat: /var/lib/postgres/data/autovacuum.pid: Permission denied
[EMAIL PROTECTED]:~$ sudo cat /var/lib/postgres/data/autovacuum.pid
7522
[EMAIL PROTECTED]:~$ ps -fp7522
UID PID PPID C STIME TTY TIME CMD
[EMAIL PROTECTED]:~$
Perhaps the existence of a pid file isn't enough to signify the process
actually running ;-(
Further digging shows:
[EMAIL PROTECTED]:/var/log/postgresql# cat autovacuum_log
[2005-09-24 01:03:59 AM] Error: GUC variable stats_row_level must be enabled.
[2005-09-24 01:03:59 AM] Please fix the problems and try again.
Perhaps after starting pg_autovacuum, check after 2 sec to see if it
remains running, and if not, point to the log file. I can imagine some
people having a hard time diagnosing this.
Thanks,
Paul
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
