లాజికల్ రెప్లికేషన్ అంటే ఏమిటి మరియు ఇది ఎప్పుడు ఉపయోగకరంగా ఉంటుంది?

PHYSICAL (streaming) → replicates the ENTIRE cluster at the storage/WAL level
  ✓ exact copy, simple   ✗ all-or-nothing, same Postgres version, read-only replica

LOGICAL → replicates specific TABLES' changes via a publish/subscribe model
  ✓ SELECTIVE (choose tables), CROSS-VERSION, to DIFFERENT schemas, replica is WRITABLE
  ✗ more setup, some limitations (DDL not replicated automatically, etc.)