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

From Edilmar LISTAS
Subject Re: Doubts about replication from many servers
Date
Msg-id 461517c8-5a8f-823c-87db-93048a6e455e@intersite.com.br
Whole thread Raw
In response to Re: Doubts about replication from many servers  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
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
>> 4 PG backup servers?
>
> More information is needed:
>
> 1) Are all 4 PG servers the same version, on the same OS, same chip
> architecture?

Right, 4 PG main servers with same version/OS/arch.

>
> 2) What replication method do you want to use?
>

Just to create a backup "big" PG server.
I think the suggestion from Walter Cachique in another message about to
use one different port for each backup server, and configure 4 backups
may be a good solution.

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



pgsql-general by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: SERIALIZABLE and INSERTs with multiple VALUES
Next
From: CS DBA
Date:
Subject: Re: checkpoint write errors ( getting worse )