Skip to content

Instantly share code, notes, and snippets.

@cwebberOps
Created May 12, 2014 23:47
Show Gist options
  • Save cwebberOps/38ca902ae25a37952a00 to your computer and use it in GitHub Desktop.
Save cwebberOps/38ca902ae25a37952a00 to your computer and use it in GitHub Desktop.
Understand Postgres Extensions in Prod

As we setup our rails environment we added the following to our schema.rb:

  enable_extension "plpgsql"
  enable_extension "pg_trgm"

As we move to prod the reality is that enabling those extensions requires a super user. How do people handle this kind of migration in Prod? Is it done separate from the schema.rb?

And if it is done separate how do you handle it in tests? Just not sure where to go with this...

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment