Re: Doubts about replication from many servers

Поиск
Список
Период
Сортировка
От Cachique
Тема Re: Doubts about replication from many servers
Дата
Msg-id CAEfeRhWr8gXj_BFyPwWejQAaOYCX-HLo7FVKySN=ub58-hu+Aw@mail.gmail.com
обсуждение исходный текст
Ответ на Doubts about replication from many servers  (Edilmar LISTAS <edilista@intersite.com.br>)
Список pgsql-general
Дерево обсуждения
Hi.
You mean one and only one big cluster with all databases from your 4 PG servers ?
What about running 4 clusters (different ports) in your backup server and each taking replication from your master servers.

Regards,
Walter

On Fri, Oct 21, 2016 at 12:09 PM, Edilmar LISTAS <edilista@intersite.com.br> 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?

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



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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

Предыдущее
От: George Woodring
Дата:
Сообщение: Best way to find last data sample before a given time
Следующее
От: CS DBA
Дата:
Сообщение: checkpoint write errors