Re: Doubts about replication from many servers

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Edilmar LISTAS <edilista(at)intersite(dot)com(dot)br>, pgsql-general(at)postgresql(dot)org
Subject: Re: Doubts about replication from many servers
Date: 2016-10-21 16:48:50
Message-ID: 6574d204-cea8-e1f3-fdba-91aa5804dfda@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jason Dusek 2016-10-21 20:53:49 Large empty table, balanced INSERTs and DELETEs, not being vacuumed
Previous Message CS DBA 2016-10-21 15:49:11 checkpoint write errors