| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Jacob Coby <jcoby(at)listingbook(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: autovacuum template0 |
| Date: | 2006-06-22 21:35:26 |
| Message-ID: | 7297.1151012126@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Jacob Coby <jcoby(at)listingbook(dot)com> writes:
> I've got a pg 8.1.1 server running autovacuum, and it started attempting
> to vacuum template0.
> 2006-06-22 15:00:50 EDT LOG: autovacuum: processing database "template0"
> 2006-06-22 15:00:50 EDT ERROR: could not access status of transaction
> 3242180415
template0 should surely not contain any such transaction number. Either
there's something you're not telling us about the history of this
installation, or template0 contains corrupt data, or ???.
What does the pg_database row for template0 contain? If you clone
template0 (CREATE DATABASE foo WITH TEMPLATE template0), does a vacuum
in the new database succeed?
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jacob Coby | 2006-06-22 21:44:00 | Re: autovacuum template0 |
| Previous Message | Tom Lane | 2006-06-22 21:15:51 | Re: How to optimize PostgreSQL database size |