1

I'm trying to add a database extension to one of my applications, specifically the fuzzystrmatch extension. Whenever I try to add it I get the following error

-- execute("CREATE EXTENSION fuzzystrmatch") rake aborted! An error has occurred, this and all later migrations canceled:

PGError: ERROR:  permission denied to create extension "fuzzystrmatch" HINT:  Must be superuser to create this extension. : CREATE EXTENSION fuzzystrmatch

The only thing I've found about becoming a superuser is this:

https://blog.engineyard.com/2012/postgresql-9-1-is-now-in-beta`

What I don't know is how to do it? Do I ssh into the database then have to sudo execute the command? Everything I've found has been very unhelpful. Any help is appreciated thanks.

Jeff Atwood
  • 63,320
  • 48
  • 150
  • 153
Mysrt
  • 3,044
  • 2
  • 17
  • 14

1 Answers1

5

Disclaimer: I'm one of Engine Yard's DBAs.

On Engine Yard your application's DB user account is not a superuser. You do have access to the superuser account, however - just use the "postgres" user instead. Obviously you would only want to use this for administrative tasks, and not from within your application!

That said, Engine Yard already provides a means to enable this and other extensions for Postgres, as mentioned at the end of the blog post you linked. You can customise your environment using chef recipes, and we provide recipes to enable postgres extensions in our custom chef repo located at: https://github.com/engineyard/ey-cloud-recipes/tree/master/cookbooks/postgresql9_extensions

If you're already using custom chef recipes in your environment then getting that set up should be straight forward - if not, I recommend you start with the documentation here: https://support.cloud.engineyard.com/entries/21009867-Customize-Your-Environment-with-Chef-Recipes

If you run into trouble with any of this, then please open a ticket and we'll be glad to assist!

John Dalton
  • 186
  • 4
  • This is really unhelpful. – Roman Jul 11 '18 at 22:49
  • Hi Roman! This is an old answer, but it mostly still applies. Please let me know how it could be more clear, or what parts of the original question you feel aren't answered here? – John Dalton Jul 13 '18 at 00:37