Why doens't my Postgres user have permissions to add a Postgres database?
Posted
by
orokusaki
on Server Fault
See other posts from Server Fault
or by orokusaki
Published on 2012-12-15T19:19:54Z
Indexed on
2012/12/15
23:06 UTC
Read the original article
Hit count: 487
First, I ran:
sudo su postgres
createuser -U postgres foouser -P
which worked fine, and I ran:
createdb -U foouser -E utf8 -O foouser foodatabase -T template0
and got "permission denied: cannot create database"
Firstly, should I even su as postgres to do operations like the first one (assuming my postgres data dir is owned by postgres), or is -U postgres from any user (assuming trust is used in pg_hba.conf) sufficient?
Secondly, why am I running into this error? Is this because the user foouser is a non-superuser? Should I create foodatabase using the postgres user and simply -O foouser?
© Server Fault or respective owner