本文是小编为大家收集整理的关于通过命令行删除postgresql数据库的处理/解决方法，可以参考本文帮助大家快速定位并解决问题，中文翻译不准确的可切换到English标签页查看源文。
问题描述
我正在尝试删除我的数据库并通过命令行创建一个新数据库.我使用 psql -U 用户名登录，然后执行 \connect template1，然后是 DROP DATABASE 数据库名称；
我收到错误"其他用户正在访问数据库数据库名称".我关闭了 apache 并尝试了这个，但仍然收到此错误.我做错了吗?
谢谢
你可以运行dropdb 命令行中的命令:
dropdb 'database name'
请注意，您必须是超级用户或数据库所有者才能删除它.
您还可以检查 pg_stat_activity 视图以查看当前针对您的数据库发生的活动类型，包括所有空闲进程.
SELECT * FROM pg_stat_activity WHERE datname='database name';
问题描述
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
推荐答案
You can run the dropdb command from the command line:
dropdb 'database name'
Note that you have to be a superuser or the database owner to be able to drop it.
You can also check the pg_stat_activity view to see what type of activity is currently taking place against your database, including all idle processes.
SELECT * FROM pg_stat_activity WHERE datname='database name';
更多相关问答
联系站长