[NOVICE] Adding a third DR PostgreSQL native replication - Mailing list pgsql-novice

From vinayak spratt
Subject [NOVICE] Adding a third DR PostgreSQL native replication
Date
Msg-id MEXPR01MB18002AF3603275FF52FB5409F1210@MEXPR01MB1800.ausprd01.prod.outlook.com
Whole thread Raw
Responses Re: [NOVICE] Adding a third DR PostgreSQL native replication  (Yaser Raja <yrraja@gmail.com>)
List pgsql-novice

Hi All


We have been using PostgreSQL 9.3 with pgpool 3.4 in a two node cluster with native streaming replication between the two nodes . 


We have a third PostgreSQL 9.3 server in DR and we just copy the backups and wal files to this server. I wanted to know if we can create native streaming replication between the replica (or would need to be from primary) and the DR and would this have any drawbacks. Would this be the same are setting up replication as normal, is there a article or blog where I can read how this is done. 


Thanks in advance. 


Regards

Vin 




pgsql-novice by date:

Previous
From: KARIN SUSANNE HILBERT
Date:
Subject: [NOVICE] How to configure Microsoft Access to connect to aPostgreSQL database?
Next
From: Bogdan Zlatanov
Date:
Subject: [NOVICE] SELECT FOR UPDATE with ORDER BY