Postgres Pro
Downloads
Home   >   mailing lists

Create a logical and physical replication - Mailing list pgsql-general

From Ashok Kumar Tiwari
Subject Create a logical and physical replication
Date
Msg-id CADQhkWF2n3mjSPLkvGNomCJO9OY++2P0dL-J45dFPtiLV75J5A@mail.gmail.com
Whole thread Raw
Responses Re: Create a logical and physical replication
Re: Create a logical and physical replication
List pgsql-general
Tree view
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,
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.

pgsql-general by date:

Previous
From: Ravi Krishna
Date:
Subject: Re: explain plan difference
Next
From: Michael Shapiro
Date:
Subject: Re: select view definition from pg_views feature request