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

From Maria L. Wilson
Subject Re: postgres 8.2.9 can't drop database in single user mode
Date
Msg-id 49EE4744.2010709@nasa.gov
Whole thread Raw
In response to postgres 8.2.9 can't drop database in single user mode  ("Maria L. Wilson" <Maria.L.Wilson-1@nasa.gov>)
List pgsql-admin
this is the command that i used to start the backend....

postgres --single -D /data/pg_devices ange


Maria L. Wilson wrote:
> 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>
>
>
>

pgsql-admin by date:

Previous
From: "Maria L. Wilson"
Date:
Subject: postgres 8.2.9 can't drop database in single user mode
Next
From: Tom Lane
Date:
Subject: Re: postgres 8.2.9 can't drop database in single user mode