通过命令行删除postgresql数据库[英] Drop postgresql database through command line

本文是小编为大家收集整理的关于通过命令行删除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';

本文地址:https://www.itbaoku.cn/post/597383.html

问题描述

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';