3 ms·

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 ac

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 3y ago
Hey, supabase employee here. We allow you to use logical replication - https://supabase.com/docs/guides/database/replication https://supabase.com/docs/guides/database/replication AFAIK all the others mentioned do not allow logical replication as you noted.
SahAssar 3y ago
Can I ask what your use-case is for logical replication on something like neon?
- cpursley 3y ago
  So I can run something like Supabase or WalEx which subscribe to WAL changes.
  - SahAssar 3y ago
    Ah, gothca. I've mostly used triggers and LISTEN/NOTIFY for those things, so haven't tried the WAL methods.
    - cpursley 3y ago
      There’s significant limitations with the trigger approach.
      - SahAssar 3y ago
        Just an FYI: neon just released logical replication.
        ajc23 3y ago
        https://neon.tech/blog/change-data-capture-with-serverless-postgres https://neon.tech/blog/change-data-capture-with-serverless-p...