Hi Roger! Roger Leigh [2005-07-20 23:06 +0100]: > > That's odd... /etc/postgresql/8.0/main/autovacuum_log should be > > automatically created and point to > > /var/log/postgresql/pg_autovacuum-8.0-main.log. Does any of the files > > not exist on your system? > > Apparently not: > > $ ls -l /etc/postgresql/8.0/main > total 17 > lrwxrwxrwx 1 root root 43 2005-03-31 11:41 log -> > /var/log/postgresql/postgresql-8.0-main.log > lrwxrwxrwx 1 root root 28 2005-03-31 11:41 pgdata -> > /var/lib/postgresql/8.0/main/ > -rw-r----- 1 postgres postgres 3191 2005-03-31 11:41 pg_hba.conf > -rw-r----- 1 postgres postgres 1460 2005-03-31 11:41 pg_ident.conf > -rw-r--r-- 1 postgres postgres 11040 2005-03-31 11:41 postgresql.conf > > $ ls -l /var/log/postgresql > total 248 > -rw-r--r-- 1 postgres postgres 127208 2005-03-31 08:19 autovacuum_log
D'oh, this file is supposed to be in /etc/postgresql/8.0/main. That's probably from a bug in an ancient experimental package which is fixed now. So if you want to dump the cluster, then drop it (pg_dropcluster) and recreate it, that would solve not only this bug, but would give you also a bunch of other new features that were introduced recently into postgresql-common. If you don't want to do this, create the log file and symlink as I described in my previous reply. Thanks, Martin -- Martin Pitt http://www.piware.de Ubuntu Developer http://www.ubuntulinux.org Debian Developer http://www.debian.org
signature.asc
Description: Digital signature
