Re: Doubts about replication from many servers

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