Adding a third DR PostgreSQL native replication

From: vinayak spratt <vin_spratt(at)hotmail(dot)com>
To: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Adding a third DR PostgreSQL native replication
Date: 2017-03-09 01:30:44
Message-ID: MEXPR01MB18002AF3603275FF52FB5409F1210@MEXPR01MB1800.ausprd01.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Bogdan Zlatanov 2017-03-09 10:51:17 SELECT FOR UPDATE with ORDER BY
Previous Message Neha Khatri 2017-03-07 23:58:11 Re: [NOVICE] opr_charset rule in gram.y