loading data into cluster - can I daisy-chain streamingreplication? - Mailing list pgsql-general

From Florin Andrei
Subject loading data into cluster - can I daisy-chain streamingreplication?
Date
Msg-id a7eeab2958372b2b2cf20683386c58eb@andrei.myip.org
Whole thread Raw
Responses Re: loading data into cluster - can I daisy-chain streaming replication?  (Dennis <dennisr@visi.com>)
List pgsql-general
I have an old production instance, let's call it A, that I need to
decommission soon.

I've created a pair of new instances, B and C, with B replicating to C,
following this procedure:

https://wiki.postgresql.org/wiki/Streaming_Replication

But B and C have no data yet. I need to transfer all data from A into B.

Can I daisy-chain streaming replication? In other words, temporarily
setup replication like this:

A ==> B ==> C

And after the transfer is done, just remove A from the scheme.


--
Florin Andrei
http://florin.myip.org/


pgsql-general by date:

Previous
From: Jim Nasby
Date:
Subject: Re: json indexing and data types
Next
From: Dennis
Date:
Subject: Re: loading data into cluster - can I daisy-chain streaming replication?