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                                          [EMAIL PROTECTED]
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 


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to