Re: Doubts about replication from many servers

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: Doubts about replication from many servers
Дата
Msg-id 6574d204-cea8-e1f3-fdba-91aa5804dfda@aklaver.com
обсуждение исходный текст
Ответ на Doubts about replication from many servers  (Edilmar LISTAS <edilista@intersite.com.br>)
Ответы Re: Doubts about replication from many servers  (Edilmar LISTAS <edilista@intersite.com.br>)
Список pgsql-general
On 10/21/2016 08:09 AM, Edilmar LISTAS wrote:
> Hi,
>
> I have 4 PG servers where each one runs many databases.
>
> Now, I would like to create just one PG backup server to replicate all
> the databases from 4 PG servers, is it possible? Or Do I need to create
> 4 PG backup servers?

More information is needed:

1) Are all 4 PG servers the same version, on the same OS, same chip
architecture?

2) What replication method do you want to use?

>
> And if some PG server goes down, how to recovery the system from PG
> backup after I reconfigure the PG original server?
>
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com


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

Предыдущее
От: CS DBA
Дата:
Сообщение: checkpoint write errors
Следующее
От: Jason Dusek
Дата:
Сообщение: Large empty table, balanced INSERTs and DELETEs, not being vacuumed