I am particularly interested in a comparaison between this new one from Supabase...

cpursley · 2023-12-16T09:17:01.000000Z

Main thing I want to know: which of the managed Postgres services allow for logical replication.

I love Heroku, render and neon is promising - but non allow access to the WAL.

kevinbrolly · 2023-12-16T09:41:31.000000Z

Hey, supabase employee here. We allow you to use logical replication - https://supabase.com/docs/guides/database/replication

AFAIK all the others mentioned do not allow logical replication as you noted.

SahAssar · 2023-12-16T11:46:17.000000Z

Can I ask what your use-case is for logical replication on something like neon?

cpursley · 2023-12-16T13:15:47.000000Z

So I can run something like Supabase or WalEx which subscribe to WAL changes.

SahAssar · 2023-12-16T13:38:16.000000Z

Ah, gothca. I've mostly used triggers and LISTEN/NOTIFY for those things, so haven't tried the WAL methods.

cpursley · 2023-12-17T19:22:20.000000Z

There’s significant limitations with the trigger approach.

SahAssar · 2023-12-28T19:56:01.000000Z

Just an FYI: neon just released logical replication.

ajc23 · 2023-12-28T20:07:28.000000Z