Create a logical and physical replication

From: Ashok Kumar Tiwari <ashokt(at)ohumhealthcare(dot)com>
To: 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: Create a logical and physical replication
Date: 2019-11-04 13:35:24
Message-ID: CADQhkWF2n3mjSPLkvGNomCJO9OY++2P0dL-J45dFPtiLV75J5A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

Hi all,

is it possible in postgres to create one physical replica for DR(data
recovery purpose) and another one logical replica for reporting purpose

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

--
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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Kyotaro Horiguchi 2019-11-05 05:54:41 Re: Create a logical and physical replication
Previous Message Wells Oliver 2019-11-01 19:00:21 Re: to_tsvector() chopping off trailing 's' characters

Browse pgsql-general by date

  From Date Subject
Next Message Michael Shapiro 2019-11-04 13:48:50 Re: select view definition from pg_views feature request
Previous Message Ravi Krishna 2019-11-04 12:04:55 Re: explain plan difference