Behalf Of John R Pierce
Sent: Thursday, June 04, 2015 2:46 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] replicating many to one
On 6/4/2015 10:07 AM, Doiron, Daniel wrote:
> I have a situation where I need to replicate the databases in 4
> clusters on 4 individual servers to a
On Thu, Jun 4, 2015 at 12:14 PM, Doiron, Daniel wrote:
> The four source/master servers all have different databases, lets call them
> A, B, C, and D. We'd like to replicate them to one cluster that will hold
> ABCD databases.
You can use londiste [1] or slony [2] to do that.
[1] http://skytoo
lf Of John R Pierce
Sent: Thursday, June 04, 2015 2:46 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] replicating many to one
On 6/4/2015 10:07 AM, Doiron, Daniel wrote:
> I have a situation where I need to replicate the databases in 4
> clusters on 4 individual servers to a single c
On 6/4/2015 10:07 AM, Doiron, Daniel wrote:
I have a situation where I need to replicate the databases in 4
clusters on 4 individual servers to a single cluster on 1 server. So
far, the best option looks like pgpool statement-based replication,
the major down side being sequences. Does anyone k
Take a good look at http://2ndquadrant.com/en/resources/bdr/
On Thu, Jun 4, 2015 at 1:07 PM, Doiron, Daniel wrote:
> I have a situation where I need to replicate the databases in 4 clusters
> on 4 individual servers to a single cluster on 1 server. So far, the best
> option looks like pgpool st
I have a situation where I need to replicate the databases in 4 clusters on 4
individual servers to a single cluster on 1 server. So far, the best option
looks like pgpool statement-based replication, the major down side being
sequences. Does anyone know a better way to achieve this type of repl
