Create a logical and physical replication

Ashok Kumar Tiwari <[email protected]> Mon, 4 Nov 2019 19:05:24 +0530

Newsgroups	gmane.comp.db.postgresql.admin,gmane.comp.db.postgresql.general
Message-ID	<CADQhkWF2n3mjSPLkvGNomCJO9OY++2P0dL-J45dFPtiLV75J5A@mail.gmail.com>

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,
[email protected],
*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.