Re: cascade replication and multiple primary_conninfo - Mailing list pgsql-general

From John R Pierce
Subject Re: cascade replication and multiple primary_conninfo
Date
Msg-id 4FB68458.40501@hogranch.com
Whole thread Raw
In response to cascade replication and multiple primary_conninfo  ("E-Blokos" <infos@e-blokos.com>)
List pgsql-general
On 05/17/12 4:17 PM, E-Blokos wrote:
> sorry for my ignorance, but is a db like pg can work like bittorrent,
> take bits wherever it's possible so set multiple primary_conninfo,
> "secondary_conninfo" etc... ?

torrents work because the torrent itself is static and constant.

databases are dynamic, and changes are supposed to be atomic.    trying
to do N-way mesh replication while maintaining atomicity of changes
would be a nightmare.



--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast


pgsql-general by date:

Previous
From: Steve Crawford
Date:
Subject: Re: odd intermittent query hanging issue
Next
From: Jon Smark
Date:
Subject: Fetching multiple rows in single round trip