Create migration failed with supabasse
I follow the supabase docs for prisma interaction, creating a user and set connection url to schema.prisma, but when I run
prisma migrate dev, error happen: permission denied to terminate process. Detail: Only roles with privileges of the role whose process is being terminated or with privileges of the "pg_signal_backend" role may terminate this process3 Replies
Query data is ok, but migration is failed
@Coffee try running the migration using the default 'postgres' role, or grant your user the 'pg_signal_backend' permission to allow process control.
Connect to direct url (5432) with default user (postgres.project_id) will failed; Grant user permission works