Re: permission problem

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: permission problem
Date: 2014-07-12 06:47:36
Message-ID: 53C0DA08.5080204@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Paquier 2014-07-12 07:01:03 Re: debugging with gdb
Previous Message Roelof Wobben 2014-07-12 06:37:12 permission problem