Thread: Doubts about replication from many servers
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?
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.On Fri, Oct 21, 2016 at 12:09 PM, Edilmar LISTAS <edilista@intersite.com.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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/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
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? >> >> >> > >