错误：必须是数据库的所有者 [英] Error:must be owner of database
问题描述
我想删除一个名为 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:
- http://www.postgresql.org/docs/manuals/
这篇关于错误：必须是数据库的所有者的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
