Does Prisma Postgres support logical replication to work with Electric SQL?

[frigid mango]

Hi guys , does Prisma Postgres support logical replication? I am trying to use Electric SQL with Prisma Postgres. Any ideas if that is possible or not at this stage?

[timber moon]

To help others find answers, you can mark your question as solved via Right click solution message -> Apps -> ✅ Mark Solution

[slate rampart]

Hey @frigid mango

Prisma Postgres comes inbuilt with Prisma Pulse, which requires logical replication. So, yes, Prisma Postgres does support logical replication.

Are you running into any specific issue with Electric SQL?

[frigid mango]

I got a response when asking the Electric SQL team whether they support Primsa Postgres or not ("im trying to get started with Prisma Postgres but not sure if they support logical replication or is it something i can turn on?"). Their response was:

From the Electric-SQL team: "Yes, you need your Postgres host to give you a normal connection string, with a user with REPLICATION. When I looked at Prisma Postgres a little while ago, it only worked with the Prisma client."

So i wonder if you provide such connection string, and "user" with "REPLICATION" capability.