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

From John R Pierce
Subject Re: peer-to-peer replication with Postgres
Date
Msg-id 4BE8C7FD.9000305@hogranch.com
Whole thread Raw
In response to Re: peer-to-peer replication with Postgres  (Scott Marlowe <scott.marlowe@gmail.com>)
Responses Re: peer-to-peer replication with Postgres  (Scott Marlowe <scott.marlowe@gmail.com>)
List 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?



pgsql-general by date:

Previous
From: Mike Christensen
Date:
Subject: Re: peer-to-peer replication with Postgres
Next
From: Scott Marlowe
Date:
Subject: Re: peer-to-peer replication with Postgres