Re: fatal error on 8.1 server

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)com>, Martijn van Oosterhout <kleptog(at)svana(dot)org>, pgsql-general(at)postgresql(dot)org
Subject: Re: fatal error on 8.1 server
Date: 2006-11-27 22:43:32
Message-ID: 25171.1164667412@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
> Tony Caduto wrote:
>> I did not have autovacuum turned on and I usually do a vacuumdb -z -a -f
>> -q each night but this one slipped through the cracks :-(

> Strange -- autovacuum should have started an automatic database-wide
> vacuum on that database, even if disabled.

We only added that in 8.2, no? 8.1 autovacuum would have forced the
vacuum to occur, but only if it was enabled in postgresql.conf.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Ribe 2006-11-27 22:47:28 Re: IS it a good practice to use SERIAL as Primary Key?
Previous Message rnshah 2006-11-27 22:40:30 CertFirst Legit?