我想删除一个名为 mysitedb的特定数据库,所以我要做的是打开终端并输入命令 dropdb mysitedb,然后弹出错误 ERROR:必须是数据库mysitedb的所有者。我知道用户名并通过了特定的数据库,但是没有删除它的线索。我是Postgresql的新手。温柔:P
I want to delete a particular database which I have named 'mysitedb' so what I did is I opened the terminal and entered the command 'dropdb mysitedb' then the error 'ERROR: must be owner of database mysitedb' pops up. I know the username and pass for the particular database but don't have a clue on deleting it. I am new to postgresql. be gentle :P
推荐答案
问:我想删除一个名为$的特定数据库b $ b'mysitedb',所以我要做的是打开终端并输入命令'dropdb mysitedb',然后弹出错误'ERROR:必须是数据库mysitedb的所有者...
Q: I want to delete a particular database which I have named 'mysitedb' so what I did is I opened the terminal and entered the command 'dropdb mysitedb' then the error 'ERROR: must be owner of database mysitedb' pops up...
确定-这意味着您没有正确的凭据。您需要具有删除该数据库权限的PostgreSQL用户的用户名/密码。
OK - this means you don't have the right credentials. You need the username/password of a postgresql user with permissions to delete that database.
注意:我知道拥有该数据库的用户。我也知道密码。
NOTE: I know the user who owns it. Also I know the password.
什么 ???
无论如何:您要 dropdb 命令:
dropdb -U db_owner_username -i [-h主机] mysitedb
这是Postgresql文档页面:
Here is the Postgresql documentation page:
- www.postgresql/docs / manuals /
- www.postgresql/docs/manuals/
更多推荐
错误:必须是数据库的所有者
发布评论