P
Prisma2mo ago
eyeziq

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
Nurul
Nurul2mo ago
Hello 👋 I assume the user with which you are trying the replication slot doesn't have Superuser access?
eyeziq
eyeziq5w ago
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.
Nurul
Nurul4w ago
Makes sense! 👍 Thank you so much for getting back and letting us know