Postgres Logical Replication for Reporting Replicas: The Gotchas the Tutorials Skip

If you've read a Postgres logical replication tutorial, you know the drill. CREATE PUBLICATION on the primary, CREATE SUBSCRIPTION on the replica, wait a few seconds, and boom — your data is flowing.