| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Database OID xxxxx now seems to belong to "foo" |
| Date: | 2008-03-11 15:40:34 |
| Message-ID: | 20080311154034.GP9116@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Gauthier, Dave wrote:
> I'm running 8.2.0 on Linux.
You should be running 8.2.6.
> The postgres.conf has...
>
> #autovacuum = off
>
> (commented out) which lead me to believe that by default, it's on. And
> I'm assuming that it's vacumming the system tables. Are these
> assumptions right?
It's not turned on by default (and it's not on 8.2), so it's probably
not vacuuming anything. On 8.2 there are enough protections that this
shouldn't be the actual problem though -- as soon as you get anywhere
near a failure, the system shuts itself down (but autovac gets a chance
to fix the problem for you before that happens, even if it's turned
off).
Perhaps it's a bug fixed between 8.2.0 and 8.2.6 (which is why you
should upgrade), but perhaps it hasn't been discovered yet. So please
upgrade and let us know if you can reproduce it on 8.2.6.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2008-03-11 15:56:24 | Re: Database OID xxxxx now seems to belong to "foo" |
| Previous Message | Greg Sabino Mullane | 2008-03-11 15:37:17 | Re: On defining Perl functions within PLPERL code |