On 28 Jan 2016 6:51 pm, "Craig Ringer" <cr...@2ndquadrant.com> wrote: > > 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
Hi Craig, Thanks a lot for all the help and really appreciated. I am still reading and will ask here if I have any questions. Regards, Kaushal
