pg_audit_log will not work on heroku #11

Activity

1. amarshall commented on Nov 18, 2014

   

   amarshall

   on Nov 18, 2014

   Contributor

   More actions

   For reference, what’s the exact error you get?
2. danielgrippi commented on Nov 30, 2014

   

   danielgrippi

   on Nov 30, 2014

   ContributorAuthor

   More actions

   @amarshall unfortunately, I don't have the exact output, but I can specify the reason:

   Since heroku doesn't give its users superuser access to their postgres instances, it's impossible for someone to run a CREATE OR REPLACE PROCEDURAL LANGUAGE command via psql. The function in function.rb will abort at the first line of the SQL setup.

   My workaround was to remove the line, as there's no need to ensure plpgsql is present, because it is by default on 9.3.

   One solution would be wrapping this line in a BEGIN; EXCEPTION; block. Another would be to remove the line entirely, which would drop support for postgres 8.x versions (seems a bit heavy handed). Thoughts?
3. MrJaba

   added a commit that references this issue on May 26, 2015

   Remove create plpgsql language line. This wont work on heroku - see C…

   ...

   272816a