Re: Streaming replication issue - Mailing list pgsql-admin

From Juan José Santamaría Flecha
Subject Re: Streaming replication issue
Date
Msg-id CAC+AXB3D-RAhngb_3UyU-uU_G7joGyAVSoeCnkD07NsKmppSag@mail.gmail.com
Whole thread Raw
In response to Re: Streaming replication issue  (John Wiencek <jwiencek3@comcast.net>)
Responses Re: Streaming replication issue  (mallikarjun t <mallit333@gmail.com>)
List pgsql-admin
On Thu, Sep 5, 2019 at 6:23 PM John Wiencek <jwiencek3@comcast.net> wrote:
>
> Multi master requires that you identify one node as the primary node.   Data is populated to the remote node via an
initialsnapshot.   Tables on the remote node cannot exist when you run the initial snapshot.  The snapshot will create
allobjects on the remote node . 
>
>
> xDB(multi-master replication) will not merge two databases together.
>
> >
> > I am under impression that what you are trying to do is merging two
> > Primary databases. If that is what you actually want then Streaming
> > Replication is not going to work for you. Maybe you should look for
> > some Multi-master replication tool, which is probably the way to go if
> > you want to mix PostgreSQL and EDB Advanced Server anyway.
> >

By "you" I meant Mallikarjun and "merge" was meant to be as generic as
possible, since I do not have a clear picture of the problem.

Maybe if the original poster comments on the topic we can give him
better advice.

Regards,

Juan José Santamaría Flecha



pgsql-admin by date:

Previous
From: John Wiencek
Date:
Subject: Re: Streaming replication issue
Next
From: mallikarjun t
Date:
Subject: Re: Streaming replication issue