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?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/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@intersite.com.br>
wrote:
Show quoted text
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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/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?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general