Fly Postgres, Managed by Supabase

Re:Fly Postgres, Managed by Supabase by cpursley on Saturday December 16, 2023 @04:17AM (#38662939)

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.

[ Parent | on HN ]

Re:Fly Postgres, Managed by Supabase by kevinbrolly on Saturday December 16, 2023 @04:41AM (#38663037)

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.

[ Parent | on HN ]

Re:Fly Postgres, Managed by Supabase by SahAssar on Saturday December 16, 2023 @06:46AM (#38663567)

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

[ Parent | on HN ]

Re:Fly Postgres, Managed by Supabase by cpursley on Saturday December 16, 2023 @08:15AM (#38663959)

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

[ Parent | on HN ]

Re:Fly Postgres, Managed by Supabase by SahAssar on Saturday December 16, 2023 @08:38AM (#38664086)

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

[ Parent | on HN ]

Re:Fly Postgres, Managed by Supabase by cpursley on Sunday December 17, 2023 @02:22PM (#38675544)

There’s significant limitations with the trigger approach.

[ Parent | on HN ]

Re:Fly Postgres, Managed by Supabase by SahAssar on Thursday December 28, 2023 @02:56PM (#38797839)

Just an FYI: neon just released logical replication.

[ Parent | on HN ]

Re:Fly Postgres, Managed by Supabase by ajc23 on Thursday December 28, 2023 @03:07PM (#38797972)

[ Parent | on HN ]