Hello. At Mon, 4 Nov 2019 19:05:24 +0530, Ashok Kumar Tiwari <ashokt@xxxxxxxxxxxxxxxxxx> 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
