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
>
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 |