Prisma #executeRaw for PostgreSQL System level ope...
# orm-help
m
Prisma #executeRaw for PostgreSQL System level operations: I am trying to set various options for Postgres using Prisma: ALTER SYSTEM SET wal_level='logical'; ALTER SYSTEM SET max_wal_senders='10'; ALTER SYSTEM SET max_replication_slots='10'; Can I set these with the prisma.$executeRaw function?
r
Hey @Martïn 👋 Unfortunately this isn’t possible with
$executeRaw
currently. Do follow this open request here for more updates 🙂
m
This is a very important feature for us that will allow us use Supabase with Prisma for automatic subscription as a requirement. Thanks for the link
r
Do add a 👍 there along with your use-case so that we can set the priority for this 🙂
👍 2
m
Done
🙌 1
@Ryan Is it also possible I add these statements at the top of the generated .sql file?
r
If it’s just a one time operation then sure you could add that and it will run properly on Migrate 🙂
m
Thanks @Ryan !
Got it working using Docker compose ‘-c’ command for the Postgres container. Now I got realtime working for Prisma tailing Postgres using supabase/realtime 😃
💯 1
🙌 1