On Thu, 2004-07-01 at 07:25, Jens Porup wrote:
> Oh, almost forgot:
>
> Some log errors that might help:
>
> From /var/log/postgresql/autovacuum_log:
>
> [2004-07-01 01:31:59 PM] Error: GUC variable stats_row_level must be enabled.
> [2004-07-01 01:31:59 PM] Please fix the problems and try again.
This is not relevant. Add:
stats_row_level = true
in /etc/postgresql/postgresql/conf
Autovacuum needs those statistics to work out what to vacuum.
--
Oliver Elphick olly@lfix.co.uk
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA
========================================
"Therefore being justified by faith, we have peace with
God through our Lord Jesus Christ." Romans 5:1