postgres 8.2.9 can't drop database in single user mode

From: "Maria L(dot) Wilson" <Maria(dot)L(dot)Wilson-1(at)nasa(dot)gov>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: postgres 8.2.9 can't drop database in single user mode
Date: 2009-04-21 22:20:09
Message-ID: 49EE4699.9070001@nasa.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

i'm getting the following error..... any ideas why this would be in
single user mode??

backend> drop database "scoogan_userprofile_1.2"
2009-04-21 18:18:23.032 EDT [11767] [] WARNING: database "ange" must
be vacuumed within 976081 transactions
2009-04-21 18:18:23.032 EDT [11767] [] HINT: To avoid a database
shutdown, execute a full-database VACUUM in "ange".
2009-04-21 18:18:23.053 EDT [11767] [] ERROR: database
"scoogan_userprofile_1.2" is being accessed by other users
2009-04-21 18:18:23.053 EDT [11767] [] STATEMENT: drop database
"scoogan_userprofile_1.2"

backend>

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Maria L. Wilson 2009-04-21 22:23:00 Re: postgres 8.2.9 can't drop database in single user mode
Previous Message Tom Lane 2009-04-21 21:18:43 Re: [ADMIN] License Issue