Re: peer-to-peer replication with Postgres

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Mike Christensen <mike(at)kitchenpc(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: peer-to-peer replication with Postgres
Date: 2010-05-11 01:23:51
Message-ID: AANLkTimqAHErYVO3zVXp6-8A5zLX7Lef64d5ZQ-ajfGF@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, May 10, 2010 at 7:21 PM, Mike Christensen <mike(at)kitchenpc(dot)com> wrote:
> Man that sounds awesome.  I need that now.  So does that mean you'd
> have one beefy SQL server for all the updates and everything writes to
> that, and then you'd have a bunch of read-only servers and new data
> trickles into them from the master continuously?

Yep. You can also do something similar but less efficient now with
slony or some other replication engine. But they're less simple to
set up and usually less efficient than log shipping.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message bricklen 2010-05-11 01:44:09 Re: Archiver not picking up changes to archive_command
Previous Message Mike Christensen 2010-05-11 01:21:27 Re: peer-to-peer replication with Postgres