On 28 January 2016 at 21:16, Kaushal Shriyan <kaushalshri...@gmail.com> wrote:
> > > On Thu, Jan 28, 2016 at 6:32 PM, Craig Ringer <cr...@2ndquadrant.com> > wrote: > >> On 28 January 2016 at 19:16, Kaushal Shriyan <kaushalshri...@gmail.com> >> wrote: >> >>> Hi, >>> >>> Can somebody please help me understand the difference between UDR and >>> BDR with examples? >>> >> >> >> BDR is for multiple masters that all replicate to each other. >> >> UDR takes data from one server and copies it to another. One way. (By the >> way, I strongly advise you to now use pglogical instead of UDR). >> >> BDR: >> >> A <==> B >> >> UDR/pglogical: >> >> A ==> B >> > > Hi Craig, > > Thanks for the explanation. Does it mean UDR is Master to Slave > replication? > > Correct. Please use either PostgreSQL's built-in streaming replication features or pglogical instead, though. If you're not sure which, use the built-in replication features. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services