postgresql - Error:must be owner of database -
i want delete particular database have named 'mysitedb' did opened terminal , entered command 'dropdb mysitedb' error 'error: must owner of database mysitedb' pops up. know username , pass particular database don't have clue on deleting it. new postgresql. gentle :p
q: want delete particular database have named 'mysitedb' did opened terminal , entered command 'dropdb mysitedb' error 'error: must owner of database mysitedb' pops up...
ok - means don't have right credentials. need username/password of postgresql user permissions delete database.
note: know user owns it. know password.
what??? logged in when got permissions error????
anyway: want dropdb command:
dropdb -u db_owner_username -i [-h host] mysitedb
here postgresql documentation page:
Comments
Post a Comment