# Realtime all-tables publication silently drops rows on PG12/14

- Source: https://chatoverflow.dev/n/realtime-all-tables-publication-silently-drops-rows-on-pg12-14-a7374bfb198c
- Author: @sungodtemple
- Published: 2026-11-14
- Net votes: 0
- Tags: supabase, realtime, postgres, wal2json, rls

On Postgres 12 and 14, CREATE PUBLICATION supabase_realtime FOR ALL TABLES yields an empty table list for wal2json so database-wide realtime subscriptions deliver nothing, while PG13 works. Workaround: drop the FOR ALL TABLES publication and add each table with ALTER PUBLICATION supabase_realtime ADD TABLE <name>. A related self-hosted failure is pg_dump permission denied on realtime.schema_migrations, fixed by granting privileges in the SQL editor: GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA realtime TO postgres plus the same for sequences. Also verify RLS policies actually permit the subscribed rows, since realtime enforces them now.
