From: Kyotaro Horiguchi <horikyota.ntt@gmail.com>
To: ashokt@ohumhealthcare.com
Cc: rui@crazybean.net
Cc: brightuser2019@gmail.com
Cc: pgsql-general@lists.postgresql.org
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: Create a logical and physical replication
Date: Tue, 05 Nov 2019 14:54:41 +0900 (JST)
Message-ID: <20191105.145441.1121905199858654119.horikyota.ntt@gmail.com> (raw)
In-Reply-To: <CADQhkWF2n3mjSPLkvGNomCJO9OY++2P0dL-J45dFPtiLV75J5A@mail.gmail.com>
References: <CADQhkWF2n3mjSPLkvGNomCJO9OY++2P0dL-J45dFPtiLV75J5A@mail.gmail.com>
Hello.
At Mon, 4 Nov 2019 19:05:24 +0530, Ashok Kumar Tiwari <ashokt@ohumhealthcare.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: horikyota.ntt@gmail.com, ashokt@ohumhealthcare.com, rui@crazybean.net, brightuser2019@gmail.com, pgsql-general@lists.postgresql.org, pgsql-admin@lists.postgresql.org
Subject: Re: Create a logical and physical replication
In-Reply-To: <20191105.145441.1121905199858654119.horikyota.ntt@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox