Postgres Pro
Downloads
Home   >   mailing lists

Thread: cascade replication and multiple primary_conninfo

cascade replication and multiple primary_conninfo

From
"E-Blokos"
Date:
Hi,
 
just wondering if PG 9.2 can accept
multiple primary_conninfo on slaves standby servers.
 
if I understood we can now replicate from slave to slave, tha'ts great,
but with only one primary_conninfo so one upstream server,
is it not a point of failure in case of the slave upstream down ?
 
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... ?
 
Thanks
 
Franck Madovsky

Re: cascade replication and multiple primary_conninfo

From
John R Pierce
Date:
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