| From: | Oliver Elphick <olly(at)lfix(dot)co(dot)uk> |
|---|---|
| To: | Jens Porup <jens(at)cyber(dot)com(dot)au> |
| Cc: | pgsql-admin(at)postgresql(dot)org, smarlowe(at)qwest(dot)net |
| Subject: | Re: Postgres IDENT auth problems... |
| Date: | 2004-07-02 05:27:15 |
| Message-ID: | 1088746034.574.3993.camel@linda |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)lfix(dot)co(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | PostgreSQL Bugs List | 2004-07-02 07:50:07 | BUG #1186: Broken Index? |
| Previous Message | mike g | 2004-07-02 04:10:33 | Re: Dumping partial database content |