I'm developing a database and have a small shell script that drops the
database, creates it, and then feeds psql to create the tables etc.
I've tried to run it and get the following error:
[revcom(at)curly revcom]$ recreate
ERROR: DROP DATABASE: Database "revcom" is being accessed by other users
dropdb: database removal failed
ERROR: CREATE DATABASE: database "revcom" already exists
createdb: database creation failed
ERROR: Relation 'teams_tid_seq' already exists
ERROR: Relation 'members_mid_seq' already exists
I know that there is nobody using the database, so I can only assume it is
some left-over garbage from my first every php script (as I don't know how to
close the link openned by pg_pconnect).
How do I close any pending connections and reset the usage count so that I
can drop the database?
This email does not contain private or confidential material as it
may be snooped on by interested government parties for unknown
and undisclosed purposes - Regulation of Investigatory Powers Act, 2000
pgsql-admin by date
|Next:||From: Peter Eisentraut||Date: 2001-07-02 16:08:23|
|Subject: Re: Cannot drop database that is in use (NOT)|
|Previous:||From: Peter Eisentraut||Date: 2001-07-02 14:50:01|
|Subject: Re: Problem with SSL|