bugzilla-daemon at main.slony.info bugzilla-daemon at main.slony.info
Tue Jun 18 07:03:22 PDT 2013
http://www.slony.info/bugzilla/show_bug.cgi?id=293

           Summary: pgbench table truncation
           Product: Slony-I
           Version: 2.0
          Platform: All
        OS/Version: All
            Status: NEW
          Severity: normal
          Priority: low
         Component: docs
        AssignedTo: slony1-bugs at lists.slony.info
        ReportedBy: dwight_lowry at yahoo.com
                CC: slony1-bugs at lists.slony.info
   Estimated Hours: 0.0


In section 2.1.2, the documentation instructs the user to run the following
command to generate test data:

        pgbench -s 1 -c 5 -t 1000 -U $PGBENCHUSER -h $MASTERHOST $MASTERDBNAME

However pgbench will truncate the history table, which slony will not replicate
downstream to any slaves.  This inherently causes the database diff to fail in
section 2.1.3.1.  The '-n' parameter should be added to the pgbench command to
bypass truncation of the history table (see below):

        pgbench -n -s 1 -c 5 -t 1000 -U $PGBENCHUSER -h $MASTERHOST
$MASTERDBNAME

-- 
Configure bugmail: http://www.slony.info/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.
You are the assignee for the bug.


More information about the Slony1-bugs mailing list