Drop postgresql database through command line

Question

Hi,

I'm trying to drop my database and create a new one through the command line. I login using psql -U username and then do a connect template1, followed by a DROP DATABASE databasename;

I get the error 'database databasename is being accessed by other users'. I shutdown apache and tried this and am still getting this error. Am I doing something wrong?

Thanks

EDIT:

Traceback (most recent call last): File "drop.py", line 4, in <module> server.delete_db(session_id, 'abcd', 'postgresql') File "/usr/local/lib/python2.7/xmlrpclib.py", line 1224, in call return self.send(self.name, args) File "/usr/local/lib/python2.7/xmlrpclib.py", line 1570, in request verbose=self.verbose File "/usr/local/lib/python2.7/xmlrpclib.py", line 1264, in request return self.single_request(host, handler, request_body, verbose) File "/usr/local/lib/python2.7/xmlrpclib.py", line 1297, in single_request return self.parse_response(response) File "/usr/local/lib/python2.7/xmlrpclib.py", line 1468, in parse_response return u.close() File "/usr/local/lib/python2.7/xmlrpclib.py", line 793, in close raise Fault(**self._stack[0]) xmlrpclib.Fault: <fault 1:="" 'database="" "abcd"="" is="" being="" accessed="" by="" other="" usersklzzwxh:0002'="">

Answer 1

Dropping and creating tables through the psql interface is standard, but creating and deleting actual databases are normally done through the Control Panel API. Otherwise, the list of databases for your user could get out-of-sync with those in the Control Panel.

Creating and deleting databases using our API is quite simple; please see the syntax reference.

In Python, this would be as simple as something like this (for mysql, similar for postgresql):

import xmlrpclib
server = xmlrpclib.ServerProxy('https://api.webfaction.com/')
session_id, account = server.login('username', 'password')
server.delete_db(session_id, 'username_dbname', 'mysql')
server.create_db(session_id, 'username_dbname', 'mysql', 'db_password')

Hope that helps!

Drop postgresql database through command line

Follow this question

Related questions