Unable to create event trigger on branch, "permission denied" using `owner` role

Attempting to use pgroll to manage migrations in a zero-downtime fashion, which requires setting up some schema-infrastructure which involves creating an event trigger. When on a fresh branch from main with the owner role, I'm unable to run the initialization process:

$ pgroll init --postgres-url ...
  ERROR   Failed to initialize pgroll: pq: permission denied to create event trigger "pg_roll_handle_ddl"
Error: pq: permission denied to create event trigger "pg_roll_handle_ddl"

$ pgroll init --postgres-url ...
  ERROR   Failed to initialize pgroll: pq: permission denied to create event trigger "pg_roll_handle_ddl"
Error: pq: permission denied to create event trigger "pg_roll_handle_ddl"

Should I expect to be able to create event triggers with Neon? I found a seemingly tangential forum post, which implied triggers should be fine, but want to confirm the same for event triggers? Britt

GitHub

GitHub - xataio/pgroll: PostgreSQL zero-downtime migrations made easy

PostgreSQL zero-downtime migrations made easy. Contribute to xataio/pgroll development by creating an account on GitHub.

4 Replies

xenial-black•2y ago

Hi @britt - currently, pgroll isn't supported since it requires superuser access. Function triggers with CREATE TRIGGER are supported though (separate from pgroll ). pgroll appears to use CREATE EVENT TRIGGER brought this up with the team too - will report back if anything changes

optimistic-goldOP•2y ago

understood, thanks very much! would be great to have support for this orchestration feature

rival-black•9mo ago

Any update? Really want to adopt try/adapt pgroll

sensitive-blue•9mo ago

Event Triggers are not supported yet, unfortunately.

Gaming

Programming

Unable to create event trigger on branch, "permission denied" using `owner` role

Did you find this page helpful?