| From: | "Maria L(dot) Wilson" <Maria(dot)L(dot)Wilson-1(at)nasa(dot)gov> |
|---|---|
| To: | "Wilson, Maria Louise (LARC-E301)[SCIENCE SYSTEMS APPLICATIONS]" <m(dot)l(dot)wilson(at)nasa(dot)gov> |
| Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: postgres 8.2.9 can't drop database in single user mode |
| Date: | 2009-04-21 22:23:00 |
| Message-ID: | 49EE4744.2010709@nasa.gov |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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>
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2009-04-21 23:38:21 | Re: [ADMIN] License Issue |
| Previous Message | Maria L. Wilson | 2009-04-21 22:20:09 | postgres 8.2.9 can't drop database in single user mode |