another stupid question: Database is being accessed by other users

From: Janning Vygen <vygen(at)planwerk6(dot)de>
To: "PostgreSQL-General" <pgsql-general(at)postgresql(dot)org>
Subject: another stupid question: Database is being accessed by other users
Date: 2001-06-29 16:01:55
Message-ID: 01062918015502.02151@janning
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2001-06-29 16:14:49 Re: Re: Debian's PostgreSQL packages
Previous Message Thomas T. Veldhouse 2001-06-29 15:58:11 Re: