For this to work, the PG role that the Rails app is using has to be a superuser,...

		Legion on April 27, 2013 \| parent \| context \| favorite \| on: Rails 4 UUID primary keys with PostgreSQL For this to work, the PG role that the Rails app is using has to be a superuser, as AFAIK only superuser roles can execute CREATE EXTENSION. Does anyone consider this an issue? I have been using non-superuser roles within my Rails apps, and using an outside superuser role to add extensions with an external tool (like pgAdmin).

Yes, that's exactly I didn't include it in the migration in the example.