I'm working on Ubuntu. Following is one of my commands.
$ psql -U kuser -d postgres
Then this connects to the database. But from postgres terminal when i try
postgres=> CREATE DATABASE kdb; ERROR: permission denied to create database
When I try a similar command in Ubuntu, it gives the following
$ sudo -u kuser createdb kdb sudo: unknown user: kuser sudo: unable to initialize policy plugin
How do I create this DB?. I have sudo rights and kuser is not me.