Take the 2-minute tour ×
Ask Ubuntu is a question and answer site for Ubuntu users and developers. It's 100% free, no registration required.

I did install postgresql according to the manual. But as soon as I do rails server I see the above error.


Edit 1: the sudo -u postgres createuser roelof did the trick but now when I do rake db:create I see this errror message:

PG::InsufficientPrivilege: ERROR: permission denied to create database

share|improve this question

1 Answer 1

You can create a role with your name by running a createuser command as the postgres system user. Run this in a terminal:

 sudo -u postgres createuser roelof
share|improve this answer
thanks, solved one problem and a new problem does arise. see edit 1 –  user1052732 Jul 11 '14 at 17:58
I also found sudo -u postgres createdb roelof useful, so I could simply run psql –  Bohemian Feb 12 at 0:06

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.