Casey Duncan wrote: > We have a production system with multiple identical database > instances on the same hardware, with the same configuration, running > databases with the exact same schema. They each have different data, > but the database sizes and load patterns are almost exactly the same. > > We are running pg 8.1.5 (upgraded the day before 8.1.6 came out, oh > well ;^) and since then we have noticed the following error on two of > the servers: > > 2007-02-15 00:35:03.324 PST ERROR: could not access status of > transaction 2565134864 > 2007-02-15 00:35:03.325 PST DETAIL: could not open file "pg_clog/ > 098E": No such file or directory
Can you relate it to autovacuum? -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
