Muhammad Ali takes us through replication in Postgres:
PostgreSQL provides two main types of replication: Physical Streaming Replication and Logical Replication. In this blog post, we explore the details of Logical Replication in PostgreSQL. We will compare it with Physical Streaming Replication and discuss various aspects such as how it works, use case, when it’s useful, its limitations, and key points to keep in mind.
Logical replication is the Postgres equivalent to SQL Server replication. Read on to see how it works.