Re: peer-to-peer replication with Postgres - Mailing list pgsql-general

From Scott Marlowe
Subject Re: peer-to-peer replication with Postgres
Date
Msg-id AANLkTimqAHErYVO3zVXp6-8A5zLX7Lef64d5ZQ-ajfGF@mail.gmail.com
Whole thread Raw
In response to peer-to-peer replication with Postgres  (Mike Christensen <mike@kitchenpc.com>)
Responses Re: peer-to-peer replication with Postgres
List pgsql-general
On Mon, May 10, 2010 at 7:21 PM, Mike Christensen <mike@kitchenpc.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.

pgsql-general by date:

Previous
From: Greg Smith
Date:
Subject: Re: Archiver not picking up changes to archive_command
Next
From: bricklen
Date:
Subject: Re: Archiver not picking up changes to archive_command