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
fair-roseOP•14mo 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
itchy-amethyst•14mo ago
Did you enable logical replication for your project?
fair-roseOP•14mo ago
Oh am I being stupid
I read online it was in the conf
I feel silly if there’s a checkbox
Lol
itchy-amethyst•14mo 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.
fair-roseOP•14mo ago
Ok great thanks