Обсуждение: Re: problem with a dropped database
Hi,
I need your help!
I vacuumed an entire database because it was having a transaction wraparound problem.
Then I dropped the database.
After running ANALYZE, the entry of the database is gone as I expected.
But when I try to connect to other databases I get the same transaction wraparound error message for the database that doesn´t exsit anymore.
Can anybodoy help me with finding out what´s wrong?
Thanks
-- A Reum Lee
..:+*aRuMi*+:..
^^Dance like no one is watching,
love like you´ve never been hurt,
sing like no one is listening
and live like it´s heaven on earth.^^
On 8/14/06, Lee A Reum <areum.facu@gmail.com> wrote: > > Hi, > I need your help! > > I vacuumed an entire database because it was having a transaction wraparound > problem. > Then I dropped the database. > > After running ANALYZE, the entry of the database is gone as I expected. > But when I try to connect to other databases I get the same transaction > wraparound error message for the database that doesn´t exsit anymore. > > Can anybodoy help me with finding out what´s wrong? > from docs: "When any database approaches the billion-transaction danger level, the system begins to emit warning messages." so, maybe the database you vacuum wasn't the culprit... vacuum the other databases may help (template1 included, i'm not sure if is really necessary but...) -- regards, Jaime Casanova "Programming today is a race between software engineers striving to build bigger and better idiot-proof programs and the universe trying to produce bigger and better idiots. So far, the universe is winning." Richard Cook