News for hackers. Stuff that matters.

A comment on Teleport: Postgres replicator in Go that works without superuser permissions. Parent comment

Re:Teleport: Postgres replicator in Go that works without su... by pedrofranceschi on Thursday May 05, 2016 @10:21AM (#11636306)
No. Teleport installs triggers on all tables the first time it starts. After the first start, consistency is guaranteed because triggers will save every data mutation in a separate table (that teleport reads to generate batches for the target instance).
[ Parent | on HN ]
Re:Teleport: Postgres replicator in Go that works without su... by zzzcpan on Thursday May 05, 2016 @10:27AM (#11636361)
Yes, I understand that triggers will save every data mutation, but no matter what you do second replica is not going to see them synchronously. It's always behind and inconsistent, if first one dies - you lose some data.

EDIT: Maybe you should rename it to something like "trigger-based asynchronous replication", so people would get the right idea about the guarantees it provides.

[ Parent | on HN ]