Re: Doubts about replication from many servers

From: Cachique <cachique(at)gmail(dot)com>
To: Edilmar LISTAS <edilista(at)intersite(dot)com(dot)br>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Doubts about replication from many servers
Date: 2016-10-21 15:30:37
Message-ID: CAEfeRhWr8gXj_BFyPwWejQAaOYCX-HLo7FVKySN=ub58-hu+Aw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 <edilista(at)intersite(dot)com(dot)br>
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?
>
> And if some PG server goes down, how to recovery the system from PG backup
> after I reconfigure the PG original server?
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message CS DBA 2016-10-21 15:49:11 checkpoint write errors
Previous Message George Woodring 2016-10-21 15:21:44 Best way to find last data sample before a given time