Re: [GENERAL] autovacuum template0

2006-07-03 Thread Jacob Coby
Tom Lane wrote: Jacob Coby <[EMAIL PROTECTED]> writes: I then tried: foo=# select * from pg_catalog.pg_statistic ; ERROR: could not access status of transaction 3242180415 DETAIL: could not open file "pg_clog/0C13": No such file or directory so it seems that pg_catalog.pg_statistic has someh

Re: [GENERAL] autovacuum template0

2006-06-22 Thread Tom Lane
Jacob Coby <[EMAIL PROTECTED]> writes: > I then tried: > foo=# select * from pg_catalog.pg_statistic ; > ERROR: could not access status of transaction 3242180415 > DETAIL: could not open file "pg_clog/0C13": No such file or directory > so it seems that pg_catalog.pg_statistic has somehow become

Re: [GENERAL] autovacuum template0

2006-06-22 Thread Jacob Coby
Tom Lane wrote: Jacob Coby <[EMAIL PROTECTED]> 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

Re: [GENERAL] autovacuum template0

2006-06-22 Thread Tom Lane
Jacob Coby <[EMAIL PROTECTED]> 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 > 32421804

[GENERAL] autovacuum template0

2006-06-22 Thread Jacob Coby
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 2006-06-22 15:00:50 EDT DETAIL: could not op