Re: Postgres IDENT auth problems... - Mailing list pgsql-admin

From Oliver Elphick
Subject Re: Postgres IDENT auth problems...
Date
Msg-id 1088746034.574.3993.camel@linda
Whole thread Raw
In response to Re: Postgres IDENT auth problems...  (Jens Porup <jens@cyber.com.au>)
List pgsql-admin
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


pgsql-admin by date:

Previous
From: mike g
Date:
Subject: Re: Dumping partial database content
Next
From: teknet@poczta.onet.pl
Date:
Subject: 7.4.3 initdb: could not create semaphores