https://supabase.com/ logo
Logical Replication with Supabase as Subscriber is...
# help
z
Logical Replication with Supabase as Subscriber is not working. We're seeing this warning "out of background worker slots" even on paid plan. Could there be something else we're missing?
n
Hello @zenny.eth! This thread has been automatically created from your message in #843999948717555735 a few seconds ago. We have already mentioned the @User so that they can see your message and help you as soon as possible! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ``...`` menu) and select "Leave Thread" to unsubscribe from future updates. Want to change the title? Use the ``/title`` command! We have solved your problem? Click the button below to archive it.
g
Really don't know much about it, but a quick google of the issue on Postgres in general I found this comment on using logical replication:
Copy code
Update max_worker_processes parameter value to at least 16. Otherwise, you may run into issues like WARNING: out of background worker slots.
And on my hosted instance it is set to 4:
z
oh interesting, is this something I can change via sql or do I need Supabase to edit the conf file?
g
I'm sorry I don't have that level of knowledge of Postgres. I believe it is a config parameter set at start.
n
Thread was archived by @zenny.eth. Anyone can send a message to unarchive it.
14 Views