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
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?