Discussion:
permission problem
Roelof Wobben
2014-07-12 06:37:12 UTC
Permalink
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
--
Sent via pgsql-general mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
John R Pierce
2014-07-12 06:47:36 UTC
Permalink
Post by Roelof Wobben
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
--
Sent via pgsql-general mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Loading...