0

Good day! Please tell me how to implement replication in Postgresql as in the diagram. One of the masters need not replicate all of the databases. enter image description here

Craig Ringer
  • 307,061
  • 76
  • 688
  • 778
J. Bat
  • 1
  • 3
    This is not possible with the built-in replication. You can only have a single master in Postgres. Plus, Postgres' built-in replication always replicates the complete instance (= all databases) –  Oct 19 '15 at 09:06
  • http://serverfault.com/questions/234246/replication-in-pg-9-between-windows-and-linux-boxes and https://wiki.postgresql.org/wiki/Replication,_Clustering,_and_Connection_Pooling#Replication – Vivek S. Oct 19 '15 at 09:06
  • We generally ask that you try to research the topic before posting, and post if you get stuck while working on the problem. What did you already try? What have you read/investigated? – Craig Ringer Oct 19 '15 at 11:35
  • 1
    You're looking for multi-master replication in PostgreSQL. You might think you need it, but you should find some other way to solve your problem. Multi-master suffers from the limitations implied by the CAP theorem. You can have it consistent, fast, or highly available, but you don't get all three. Latency is a killer for synchronous replication, and asynchronous replication requires a keen understanding of the complexities of multi-master conflicts. Really, it's hard. Don't do this. Solve the problem another way. (There are exceptions, but there's nowhere near enough info here). – Craig Ringer Oct 19 '15 at 11:38

0 Answers0