Re: Doubts about replication from many servers - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Doubts about replication from many servers
Date
Msg-id 6574d204-cea8-e1f3-fdba-91aa5804dfda@aklaver.com
Whole thread Raw
In response to Doubts about replication from many servers  (Edilmar LISTAS <edilista@intersite.com.br>)
Responses Re: Doubts about replication from many servers
List 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 by date:

Previous
From: CS DBA
Date:
Subject: checkpoint write errors
Next
From: Jason Dusek
Date:
Subject: Large empty table, balanced INSERTs and DELETEs, not being vacuumed