On Thu, Dec 17, 2015 at 8:36 AM, "Gonzalo Vásquez @ Waypoint"
<gvasquez at waypoint.cl> wrote:
> Hi everybody, it seems initially Slony is sending everything to the slave
> node (700 GB), and not just the “delta” data on the first sync. Once
> finished initial synchronization it is actually only sends new/modified rows
> to the slave node. Is this “first behavior” expected? If not, what could be
> misconfigured?

Yes it is. Slony has to know exactly what is on the replica in order
to keep it consistent. The best way to do that is to start with an
empty database and fill it in.

There is a way to tell slony you already have a copy there, but it has
to be done with a quiet database (ie, no other connections modifying
the DB at all).