Thread: permission problem

Hello,

I try to use postgresql with Ruby on Rails.

First I see this error ; role "roelof" does not exist.

I solved it by doing :  sudo -u postgres createuser roelof

but now when I make the database by doing rake db:create I see this error ;

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

How to solve this one?

Roelof

On 7/11/2014 11:37 PM, Roelof Wobben wrote:
> First I see this error ; role "roelof" does not exist.
>
> I solved it by doing :  sudo -u postgres createuser roelof
>
> but now when I make the database by doing rake db:create I see this
> error ;
>
> PG::InsufficientPrivilege: ERROR: permission denied to create database
>
> How to solve this one?

sudo -u postgres psql -c "alter role roelof with createdb createuser"



--
john r pierce                                      37N 122W
somewhere on the middle of the left coast