In this session we are going to about key differences between synchronous and asynchronous replication in PostgreSQL.

i) The concept of replication is changed Happening in one database are replicated into other databases

ii) It can be made in two ways
1) synchronous replication
2) Asynchronous replication

Asynchronous replication:

• It’s a standard way To replicate data in PostgreSQL

• Advantages of this replication are low overhead, simplicity & robustness.

• As a result of async replication is the ideal solution of automatic failover
  And enterprise-grade pregnancies

synchronous replication:

If you are not ready to take the risk of losing a cothe mmit sync replication is best solution

• It ensures the highest possible security of our transactions

#postgresql