Hi all,
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@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
blah blah....
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?
--
Gary Stainburn
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