From: | "Deepak Pahuja (dot)" <deepakpahuja(at)hotmail(dot)com> |
---|---|
To: | Ashok Kumar Tiwari <ashokt(at)ohumhealthcare(dot)com>, 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-general(at)lists(dot)postgresql(dot)org>, "pgsql-admin(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:15:20 |
Message-ID: | CH2PR10MB403703133179BC0DB8B7D713D67E0@CH2PR10MB4037.namprd10.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
Yes it is possible.
Get Outlook for Android<https://aka.ms/ghei36>
________________________________
From: Ashok Kumar Tiwari <ashokt(at)ohumhealthcare(dot)com>
Sent: Tuesday, November 5, 2019 7:12:45 PM
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-general(at)lists(dot)postgresql(dot)org>; pgsql-admin(at)lists(dot)postgresql(dot)org <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Create a logical and physical replication
its possible to cascade a logical replication from a binary slave replica?
[image.png]
On Tue, Nov 5, 2019 at 11:25 AM Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com<mailto: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<mailto: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<mailto:ashokt(at)ohumhealthcare(dot)com>,
M:+91-9657628833
[http://www.blystreecare.com/images/tree-clipart-4.gif] 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 | Andreas Joseph Krogh | 2019-11-05 11:40:09 | Re: Create a logical and physical replication |
Previous Message | Ashok Kumar Tiwari | 2019-11-05 11:12:45 | Re: Create a logical and physical replication |
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Joseph Krogh | 2019-11-05 11:40:09 | Re: Create a logical and physical replication |
Previous Message | Ashok Kumar Tiwari | 2019-11-05 11:12:45 | Re: Create a logical and physical replication |