Re: replicating many to one

From: Sergey Konoplev <gray(dot)ru(at)gmail(dot)com>
To: "Doiron, Daniel" <DoironD(at)advisory(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: replicating many to one
Date: 2015-06-05 02:32:42
Message-ID: CAL_0b1u57dYaroXwUXB2j2Z7k4wUT1xPK8Ef9-FoOtO6pkosCA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Jun 4, 2015 at 12:14 PM, Doiron, Daniel <DoironD(at)advisory(dot)com> 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://skytools.projects.pgfoundry.org/skytools-3.0/

[2] http://www.slony.info/

--
Kind regards,
Sergey Konoplev
PostgreSQL Consultant and DBA

http://www.linkedin.com/in/grayhemp
+1 (415) 867-9984, +7 (499) 346-7196, +7 (988) 888-1979
gray(dot)ru(at)gmail(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message William Dunn 2015-06-05 04:53:07 Re: Database designpattern - product feature
Previous Message Bill Moran 2015-06-05 02:02:51 Re: Automatic Client routing