R
R
raiboon2014-12-03 18:50:51
PostgreSQL
raiboon, 2014-12-03 18:50:51

What is the best way to replicate postgresql?

What is currently the best postgresql solution for replication?
There is a master base. There are several slaves. Both the master and the slaves must have local tables.
It is possible to raise two postgres on each server and use the usual streaming replication - stable, fast, if the slave even cuts down for an hour, then it will easily catch up.
You can take elephants or bucardo and replicate only the common db, and store in the other what should be local. No experience. Both praise. What are your opinions, which is better?
You can take skytools and replicate at the table level. No experience. And few reviews. Is it worth it? Does anyone have a successful experience?

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question