On Wed, 2004-06-30 at 09:59, Sandro Dentella wrote: > After a crash of the (frozen) system, postgreSQL issues a message: > > 2004-06-30 17:51:39 [3165] LOG: connection authorized: user=sandro database=sia > 2004-06-30 17:51:39 [3165] ERROR: could not access status of transaction 4011600129 > DETAIL: could not open file "/var/lib/postgres/data/pg_clog/0EF1": No such file or > directory > > > when trying to acces a db. > > I'm really clueless as I didn't find anything usefull with google to fix > it. The db is very little, and I'm the only one that writes on it, so I know > there shouldn't be real problems ignoring the transaction, but I don't know > what to say postgreSQL to ingore it. > > Should I recreate an empty file?
What version are you running? ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html