How data is synchronized in a Postgres cluster

There are two ways in which data is synchronized from the primary server to the standby servers:

1. Synchronous → Write transactions are not committed until all servers commit them.
2. Asynchronous → Write transactions are first committed on the primary server and then copied to the standby servers.

See the image for pros and cons of each type.