Re: [NOVICE] Adding a third DR PostgreSQL native replication

Поиск
Список
Период
Сортировка
От Yaser Raja
Тема Re: [NOVICE] Adding a third DR PostgreSQL native replication
Дата
Msg-id CALkbEVna-nneOfFJrQekrNf=LJgJ0MKFhyLp+0h=37t7STQTCQ@mail.gmail.com
обсуждение исходный текст
Ответ на [NOVICE] Adding a third DR PostgreSQL native replication  (vinayak spratt <vin_spratt@hotmail.com>)
Список pgsql-novice
Дерево обсуждения
Yes you can stream from an existing replica. This is called cascading replication. Check out the following link for details:

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@hotmail.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 





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

Предыдущее
От: Bogdan Zlatanov
Дата:
Сообщение: [NOVICE] SELECT FOR UPDATE with ORDER BY
Следующее
От: Neha Khatri
Дата:
Сообщение: [NOVICE] Why is there a doubtful copyObject call in add_vars_to_targetlist