Re: [GENERAL] Doubts about replication from many servers

2016-10-24 Thread Edilmar LISTAS
Em 21-10-2016 13:48, Adrian Klaver escreveu: 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

Re: [GENERAL] Doubts about replication from many servers

2016-10-21 Thread Adrian Klaver
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 nee

Re: [GENERAL] Doubts about replication from many servers

2016-10-21 Thread Cachique
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 wrote: > Hi, > > I h

[GENERAL] Doubts about replication from many servers

2016-10-21 Thread Edilmar LISTAS
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