Hacker News Reader

List of new features in 9.3

https://wiki.postgresql.org/wiki/What%27s_new_in_PostgreSQL_...

Cute: "Incidentally, this also makes it possible to set up 'cycles' where replication is going in a circle. Whether that's a feature or a bug depends on your perspective."

Is there any context in which it would make sense to set up circular replication? This would necessitate that all of your nodes be read-only, so I'm not sure what there would be to replicate.

In any case, a bunch of these new features are hot. Particularly excited about fast failover and custom background workers.

> Is there any context in which it would make sense to set up circular replication?

It depends on if each node in the loop knows that it's already seen the replication data before and thus logs and ignores it. That's basically how MySQL (multi-master) replication loops work.

But there's no value in closing the loop. If postgres circular replication works this way, then a -> b -> a works the same way as a -> b, so there's no new capability here.

Reply on news.ycombinator.com