PG extensions
Last modified on Wed 22 Jul 2020

If you want to use postgres extensions (for example postgis or uuid) on Amazons RDS Postgres database add this migration to your application:

def change
  if Rails.env.in? ['development', 'test']
    enable_extension 'postgis'
  else
    STDERR.puts 'TELL DEVOPS TO ENABLE Postgis ON DATABASE'
  end
end

This is because of restrictions on Amazon RDS databases. To be able to enable extension on RDS you need to be a superuser (to have access to scripts on disk). The users we are using on RDS to read and write in our databases do not have superuser rights. That is why you will need to humbly ask our devops to enable it for you.