Re: postgres 8.2.9 can't drop database in single user mode

Maria L. Wilson wrote:
> yes - how do i get rid of these??
>
> backend> select * from pg_prepared_xacts;
> 2009-04-22 07:43:27.421 EDT [11767] [] WARNING: database "ange" must
> be vacuumed within 976080 transactions
> 2009-04-22 07:43:27.421 EDT [11767] [] HINT: To avoid a database
> shutdown, execute a full-database VACUUM in "ange".
> 1: transaction (typeid = 28, len = 4, typmod = -1, byval = t)
> 2: gid (typeid = 25, len = -1, typmod = -1, byval = f)
> 3: prepared (typeid = 1184, len = 8, typmod = -1, byval = f)
> 4: owner (typeid = 19, len = 64, typmod = -1, byval = f)
> 5: database (typeid = 19, len = 64, typmod = -1, byval = f)
> ----
> 1: transaction = "339484494" (typeid = 28, len = 4, typmod = -1,
> byval = t)
> 2: gid = "257_cGMwNzQvNjAyNA==_MQ==" (typeid = 25, len = -1,

ROLLBACK PREPARED '257_cGMwNzQvNjAyNA==_MQ==';

and so on.

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.