| From: | Juan José Santamaría Flecha <juanjo(dot)santamaria(at)gmail(dot)com> |
|---|---|
| To: | John Wiencek <jwiencek3(at)comcast(dot)net> |
| Cc: | mallikarjun t <mallit333(at)gmail(dot)com>, Luca Ferrari <fluca1978(at)gmail(dot)com>, soumitra bhandary <soumitra(dot)bhandary(at)hotmail(dot)com>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Streaming replication issue |
| Date: | 2019-09-05 17:51:37 |
| Message-ID: | CAC+AXB3D-RAhngb_3UyU-uU_G7joGyAVSoeCnkD07NsKmppSag@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Thu, Sep 5, 2019 at 6:23 PM John Wiencek <jwiencek3(at)comcast(dot)net> wrote:
>
> Multi master requires that you identify one node as the primary node. Data is populated to the remote node via an initial snapshot. Tables on the remote node cannot exist when you run the initial snapshot. The snapshot will create all objects 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | mallikarjun t | 2019-09-05 18:21:32 | Re: Streaming replication issue |
| Previous Message | John Wiencek | 2019-09-05 16:23:51 | Re: Streaming replication issue |