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

owner

owner

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"

$ 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.

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

Similar Threads

Similar Threads

Similar Threads