From: | Ashok Kumar Tiwari <ashokt(at)ohumhealthcare(dot)com> |
---|---|
To: | Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com> |
Cc: | Rui DeSousa <rui(at)crazybean(dot)net>, Shital A <brightuser2019(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org, pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | Re: Create a logical and physical replication |
Date: | 2019-11-05 11:12:45 |
Message-ID: | CADQhkWH7gzphpTk57D1oFsC6vTMsnt_svQQzuoTnBqWFDjnpGg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
its possible to cascade a logical replication from a binary slave replica?
[image: image.png]
On Tue, Nov 5, 2019 at 11:25 AM Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>
wrote:
> Hello.
>
> At Mon, 4 Nov 2019 19:05:24 +0530, Ashok Kumar Tiwari <
> ashokt(at)ohumhealthcare(dot)com> wrote in
> > is it possible in postgres to create one physical replica for DR(data
> > recovery purpose) and another one logical replica for reporting purpose
>
> A physical replication standby cannot be a publisher. You will find
> that CREATE PUBLICATION fails.
>
> > master --------> physical standby (for DR Purpose)
> > |
> > |
> > |
> > |
> > logical replica for reporting purpose
> >
> > ------------------ or cascading logic replication
> >
> > master --------> physical standby (for DR Purpose) ------------- >
> > logical replica for reporting purpose
>
> The former works (as documented in [1]) but the latter doesn't.
>
>
> By the way, If I'm not missing anything I don't find a description on
> this restriction in the documentation. Shouldn't it be in [2], or
> [1]?
>
> [1]: https://www.postgresql.org/docs/12/logical-replication.html
> [2]:
> https://www.postgresql.org/docs/12/logical-replication-restrictions.html
>
> regards.
>
> --
> Kyotaro Horiguchi
> NTT Open Source Software Center
>
--
Ashok Kumar Tiwari,
Senior Technical Consultant,
ashokt(at)ohumhealthcare(dot)com,
*M*:+91-9657628833
--
Save a tree. Please avoid printing this email unless necessary.
*****
Email confidentiality notice *****
This message is private and
confidential. If you have received this message in error, please notify us
and remove it from your system.
From | Date | Subject | |
---|---|---|---|
Next Message | Deepak Pahuja . | 2019-11-05 11:15:20 | Re: Create a logical and physical replication |
Previous Message | Kyotaro Horiguchi | 2019-11-05 05:54:41 | Re: Create a logical and physical replication |
From | Date | Subject | |
---|---|---|---|
Next Message | Deepak Pahuja . | 2019-11-05 11:15:20 | Re: Create a logical and physical replication |
Previous Message | Kyotaro Horiguchi | 2019-11-05 05:54:41 | Re: Create a logical and physical replication |