Re: cascade replication and multiple primary_conninfo

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: cascade replication and multiple primary_conninfo
Date: 2012-05-18 17:18:16
Message-ID: 4FB68458.40501@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jon Smark 2012-05-18 17:46:28 Fetching multiple rows in single round trip
Previous Message Steve Crawford 2012-05-18 17:09:49 Re: odd intermittent query hanging issue