Re: postgres 8.2.9 can't drop database in single user mode - Mailing list pgsql-admin

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.