loading data into cluster - can I daisy-chain streaming replication?

From: Florin Andrei <florin(at)andrei(dot)myip(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: loading data into cluster - can I daisy-chain streaming replication?
Date: 2015-12-03 01:24:24
Message-ID: a7eeab2958372b2b2cf20683386c58eb@andrei.myip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dennis 2015-12-03 03:54:23 Re: loading data into cluster - can I daisy-chain streaming replication?
Previous Message Jim Nasby 2015-12-03 01:11:26 Re: json indexing and data types