Skip site navigation (1) Skip section navigation (2)

Re: another stupid question: Database is being accessed by other users

From: Jan Wieck <JanWieck(at)Yahoo(dot)com>
To: Janning Vygen <vygen(at)planwerk6(dot)de>
Cc: PostgreSQL-General <pgsql-general(at)postgresql(dot)org>
Subject: Re: another stupid question: Database is being accessed by other users
Date: 2001-06-29 17:15:40
Message-ID: 200106291715.f5THFen08810@jupiter.us.greatbridge.com (view raw or flat)
Thread:
Lists: pgsql-general
Janning Vygen wrote:
> 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??

    Maybe,    but   you're   using   pg_pconnect()   instead   of
    pg_connect(), turning pg_close() effectively into a NOOP.


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck(at)Yahoo(dot)com #



_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com


In response to

Responses

pgsql-general by date

Next:From: Ian HardingDate: 2001-06-29 17:21:23
Subject: pg_dump - Comments on Triggers.
Previous:From: Thomas T. VeldhouseDate: 2001-06-29 16:31:22
Subject: Re:

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group