What is the difference between physical replication and logical replication in PostgreSQL, and when would you use each?

Sample answer preview

PostgreSQL offers two distinct replication mechanisms, each suited for different use cases. Understanding when to use physical versus logical replication is important for a mid-level DBA designing a replication architecture.