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

Поиск
Список
Период
Сортировка
От Jim Nasby
Тема Re: loading data into cluster - can I daisy-chain streaming replication?
Дата
Msg-id 5660BF1D.6080308@BlueTreble.com
обсуждение исходный текст
Ответ на Re: loading data into cluster - can I daisy-chain streaming replication?  (Dennis <dennisr@visi.com>)
Список pgsql-general
On 12/2/15 9:54 PM, Dennis wrote:
> What you can do with your current configuration is do a pg_dumpall or pg_dump of A and load that logical dump into B
whichwould then replicate the data to C. 

IF you can't handle the downtime you could also setup londiste or Slony
and logically replicate A to B.

But (assuming A and B are binary compatible) you'd be better off just
breaking the B to C replication, setting B up as a replica of A, and
then setting C up as a replica of B.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com


В списке pgsql-general по дате отправления:

Предыдущее
От: Jim Nasby
Дата:
Сообщение: Re: json indexing and data types
Следующее
От: Jim Nasby
Дата:
Сообщение: Re: JSONB performance enhancement for 9.6