Document the privileges required to run pgroll

[divyenduz]

I am trying to initialize pgroll on a local Postgres (running via docker using supabase/postgres image). I get the following error:

pgroll init --postgres-url 'postgres://postgres:postgres@localhost:5432/cal?sslmode=disable'
  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"

What are the privileges to run pgroll init (and for it to function properly)?

[clarkbw]

Supabase doesn't support event triggers, CREATE EVENT TRIGGER https://supabase.com/docs/guides/database/postgres/roles-superuser

[ilyakooo0]

This also prevents pgroll from being used with Digital Ocean managed Postgres