📜 ⬆️ ⬇️

When trigger replication is preferable to PostgreSQL built-in

Since PostgreSQL version 9.0, there is a built-in Master-Slave replication mechanism (streaming replication).
However, with its appearance, old trigger mechanisms should not be thrown away.

In general, if we need something more than one absolutely exact copy of the entire DB server, then the triggers remain with us.

Examples of such situations:

')
Add additional options in the comments.

Note: The ability to build a failover is declared a month ago in version 9.1 called "Synchronous Replication". However, I personally have not yet conducted experiments.

Source: https://habr.com/ru/post/130515/


All Articles