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

Поиск
Список
Период
Сортировка
От Maria L. Wilson
Тема Re: postgres 8.2.9 can't drop database in single user mode
Дата
Msg-id 49EE4744.2010709@nasa.gov
обсуждение исходный текст
Ответ на postgres 8.2.9 can't drop database in single user mode  ("Maria L. Wilson" <Maria.L.Wilson-1@nasa.gov>)
Список 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 по дате отправления:

Предыдущее
От: "Maria L. Wilson"
Дата:
Сообщение: postgres 8.2.9 can't drop database in single user mode
Следующее
От: Tom Lane
Дата:
Сообщение: Re: postgres 8.2.9 can't drop database in single user mode