Issue with permissions for setting up replication for prisma pulse
Hi all, I am trying to use a Azure hosted postgres db and I am running into issues running through the steps for setting up the data replication that is required for pulse to work (ref: https://www.prisma.io/docs/pulse/database-setup/general-database-instructions). I was wondering if anyone has found a work around to this issue? The error that I am getting is lack of permissions I am using the user that I create when I create the database in Azure.
3 Replies
Hello 👋
I assume the user with which you are trying the replication slot doesn't have Superuser access?
Hi, yes I was able to solve the issue since then. The solution seems to be giving replication to the admin user that Azure gives you. I was trying to create a new role with replication access to then grant to the admin user instead of just granting the pre-existing REPLICATION role to the admin user.
Makes sense! 👍
Thank you so much for getting back and letting us know