Re: peer-to-peer replication with Postgres

From: John R Pierce <pierce(at)hogranch(dot)com>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: Mike Christensen <mike(at)kitchenpc(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: peer-to-peer replication with Postgres
Date: 2010-05-11 02:59:09
Message-ID: 4BE8C7FD.9000305@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Scott Marlowe wrote:
>> Is there any sort of abstraction layer (like in the driver level) that
>> can abstract that and just make updates go to one DB and reads
>> round-robin to other DBs? Hopefully there's a way to make this design
>> simple to implement.
>>
>
> Pretty sure pgpool can do the "read from these dbs, write to this one".
>

how would it know if you're going to do updates later on in a transaction?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2010-05-11 03:07:38 Re: peer-to-peer replication with Postgres
Previous Message Scott Marlowe 2010-05-11 02:14:35 Re: peer-to-peer replication with Postgres