Skip to main content
Ask A Question
Notifications
You’re not receiving notifications from this thread.
Subscribe

PG::InsufficientPrivilege: ERROR: permission denied to create extension "pgcrypto" HINT: Must be superuser to create this extension. : CREATE EXTENSION IF NOT EXISTS "pgcrypto"

Databases • Asked by Juan S. Caro

Hi everyone, I have been deploying following the guides of this site. However, I had introduced the use of UUID and so I have set the use of extensions for PostgreSQL. Now, when I deploy, I get the following error:

PG::InsufficientPrivilege: ERROR:  permission denied to create extension "pgcrypto"
HINT:  Must be superuser to create this extension.
: CREATE EXTENSION IF NOT EXISTS "pgcrypto"

It's crear that I need to be superuser, but I gave superuser power to deploy user, and I wouldn't know what to do next. Any help on that? Thanks


Login or Create An Account to join the conversation.

Subscribe to the newsletter

Join 30,005+ developers who get early access to new screencasts, articles, guides, updates, and more.

    By clicking this button, you agree to the GoRails Terms of Service and Privacy Policy.

    More of a social being? We're also on Twitter and YouTube.