permission denied to create extension "uuid-ossp"

Question

I'm building a Rails project on postgresql, but when I

rake db:migrate 

I get the following error:

 permission denied to create extension "uuid-ossp" 

Here's how my database.yml looks like:

app_common: &app_common adapter: postgresql host: 127.0.0.1 port: 5432 encoding: unicode pool: 5 username: root password: 

Answer 1

Figured it out, I need to postegresql and change the root role to superuser:

$psql  ALTER USER root WITH SUPERUSER;