[Skytools-users] How do I synchronize subscriber to provider table when missing a record.

[Hannu Krosing]

On Fri, 2010-08-13 at 09:43 +0300, Marko Kreen wrote:
> On Wed, Aug 11, 2010 at 10:01 PM, Chris Barnes
> > 2010-08-11 14:58:18,958 6838 INFO Sorting src table: schema.table1
> > 2010-08-11 14:58:19,331 6838 INFO Sorting dst table: schema.table1
> > 2010-08-11 14:58:19,697 6838 INFO Comparing dumps: schema.table1
> > 2010-08-11 14:58:19,866 6838 INFO finished schema.table1: src: 70598 rows,
> > dst: 70597 rows, missed: 1 inserts, 0 updates, 0 deletes
> 
> Repair does not apply the changes by itself, but writes them out for
> examination. (fix.*)
> 
> The plan was to make it apply them automatically later,
> but that has not yet happened...

As a quick fix add one log line to output, saying 
Fixes written to file fix.schema.table1.sql 

:)

-- 
Hannu Krosing   http://www.2ndQuadrant.com
PostgreSQL Scalability and Availability 
   Services, Consulting and Training