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 <edili...@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 >
