Skip to content

Instantly share code, notes, and snippets.

@cwebberOps

cwebberOps/gist:38ca902ae25a37952a00

Created May 12, 2014 23:47
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save cwebberOps/38ca902ae25a37952a00 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save cwebberOps/38ca902ae25a37952a00 to your computer and use it in GitHub Desktop.
Download ZIP
Understand Postgres Extensions in Prod
Raw
gistfile1.md

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