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:09:35
Message-ID: AANLkTinctLniAfIh6vdCeghhXooraGohcqVVOw-tU-AQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, May 10, 2010 at 7:04 PM, Mike Christensen <mike(at)kitchenpc(dot)com> wrote:
> Thanks for the advice.  In that case, I'll stick with the standard
> approach of having a single SQL server and several web frontends and
> employ a caching mechanism such as memcache as well.  Thanks!

And with 9.0 it will be pretty easy to setup hot read PITR slaves so
you can build a pretty simple failover system.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Greg Smith 2010-05-11 01:12:00 Re: Archiver not picking up changes to archive_command
Previous Message Gordon Shannon 2010-05-11 01:07:43 Re: Crazy looking actual row count from explain analyze