Add support for pg_create_logical_replication_slot
I get the error
logical decoding requires wal_level >= logical when I try to use it. My usecase is effectively building a platform to stream changes to frontend frameworks without much effort. I can alternatively use triggers, but having a connection there slurping changes might be more efficient in cases where it is a common set of tables being affected. I am trying to use it with the wal2json extension.5 Replies
vicious-goldOP•13mo ago
I do need to do some experimenting with triggers and transactions to see if I can make a short lived transaction on the "slurp connections" for the database
quickest-silver•13mo ago
Did you enable logical replication for your project?
vicious-goldOP•13mo ago
Oh am I being stupid
I read online it was in the conf
I feel silly if there’s a checkbox
Lol
quickest-silver•13mo ago
haha no worries
All you need to do is:
1. Select your project in the Neon Console.
2. On the Neon Dashboard, select Settings.
3. Select Logical Replication.
4. Click Enable to enable logical replication.
vicious-goldOP•13mo ago
Ok great thanks