another stupid question: Database is being accessed by other users

Поиск
Список
Период
Сортировка
Искать
От
Janning Vygen
Тема
another stupid question: Database is being accessed by other users
Дата
Msg-id
01062918015502.02151@janning
Список
Дерево обсуждения
another stupid question: Database is being accessed by other users Janning Vygen <vygen@planwerk6.de>
Re: another stupid question: Database is being accessed by other users Jan Wieck <JanWieck@Yahoo.com>
Re: another stupid question: Database is being accessed by other users Janning Vygen <vygen@planwerk6.de>
Re: another stupid question: Database is being accessed by other users Jan Wieck <JanWieck@Yahoo.com>
sorry for asking again, because i could solve this problem on my own if i had 
enough time to check things.

i collect all my sql command and do
#!/bin/sh
dropdb kontaktdaten
createdb kontaktdaten
cat sql_commands | psql kontaktdaten

and often i get

ERROR:  DROP DATABASE: Database "kontaktdaten" is being accessed by other 
users    

if i do a ' ps ax | grep post ' i see some processes which are idle
2572 pts/6 S 0:00 /usr/bin/postgres localhost wwwrun kontaktdaten idle 

i always call pg_Close in my php scripts. Why are there still some processes 
and how can i achieve to drop the database??

thanks in advance for any help or suggestions

janning

В списке pgsql-general по дате отправления
От: Jan Wieck
Дата:
Сообщение: Re: function cache??
От: Mihai Gheorghiu
Дата:
Сообщение: Migrating from MSAccess
FAQ