Re: Adding a third DR PostgreSQL native replication

Yes you can stream from an existing replica. This is called cascading
replication. Check out the following link for details:

https://www.postgresql.org/docs/9.3/static/warm-standby.html#CASCADING-REPLICATION

You need the exact same steps which you used to set up the first replica.

Regards
Yaser

On Wed, Mar 8, 2017 at 8:30 PM, vinayak spratt <vin_spratt(at)hotmail(dot)com>
wrote:

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