Slony-I同步复制配置

#安装PostgreSQL数据库，主从数据库安装过程类似

[root@rhevm01 ~]# rpm -qa|grep postgres
postgresql-8.4.11-1.el6_2.x86_64
postgresql-libs-8.4.11-1.el6_2.x86_64
postgresql-server-8.4.11-1.el6_2.x86_64
postgresql-jdbc-8.4.701-8.el6.noarch
postgresql-devel-8.4.11-1.el6_2.x86_64
postgresql-contrib-8.4.11-1.el6_2.x86_64

#编译安装SlonyI，主从数据库安装过程类似

[root@rhevm01 ~]# tar -jxvf slony1-2.1.2.tar.bz2
[root@rhevm01 ~]# cd slony1-2.1.2
[root@rhevm01 slony1-2.1.2]# ./configure --with-pgconfigdir=/usr/bin
[root@rhevm01 slony1-2.1.2]# gmake all
[root@rhevm01 slony1-2.1.2]# gmake install

#编译安装slonyI检查发现pg_config不存在，是由于没有安装postgresql-devel rpm包

[root@rhevm01 slony1-2.1.2]# yum install postgresql-devel.x86_64

#新建初始化脚本urt_replica_init.sh

点击查看

[root@rhevm01 ~]# cat urt_replica_init.sh
#!/bin/sh
SLONIK=/usr/bin/slonik                 #slonik可执行文件位置
CLUSTER=URT                            #集群名称
PORT=5433                              #数据库连接端口
PWD=***********                        #密码
SET_ID=1                               #复制集的名称
MASTER=1                               #主服务器ID
HOST1="rhevm01.example.com"            #源库IP或主机名
DBNAME1=URT                            #需要复制的源数据库
SLONY_USER=postgres                    #源库数据库超级用户名
SLAVE=2                                #从服务器ID
HOST2="rhevm02.example.com"            #目的库IP或主机名
DBNAME2=URT                            #需要复制的目的数据库
PGBENCH_USER=postgres                  #目的库用户名

$SLONIK <<_EOF_

cluster name = $CLUSTER;               #定义集群名
                                       #下面两句定义复制节点
node $MASTER admin conninfo = 'dbname=$DBNAME1 host=$HOST1 port=$PORT user=$SLONY_USER password=$PWD';
node $SLAVE admin conninfo = 'dbname=$DBNAME2 host=$HOST2 port=$PORT user=$PGBENCH_USER password=$PWD';
#初始化集群和主节点，id从1开始，如果只有一个集群，那么肯定是1
#comment里可以写一些自己的注释
init cluster ( id = $MASTER, comment = 'Primary Node' );
#下面是从节点
store node ( id = $SLAVE, comment = 'Slave Node',event node = $MASTER );
#配置主从两个节点的连接信息，即告诉Slave服务器如何来访问Master服务器
#下面是主节点的连接参数
store path ( server = $MASTER, client = $SLAVE,
conninfo = 'dbname=$DBNAME1 host=$HOST1 port=$PORT user=$SLONY_USER password=$PWD');
#下面是从节点的连接参数
store path ( server = $SLAVE, client = $MASTER,
conninfo = 'dbname=$DBNAME2 host=$HOST2 port=$PORT user=$PGBENCH_USER password=$PWD');

#设置复制中角色，主节点是原始提供者，从节点是接受者
store listen ( origin = $MASTER, provider = 1, receiver = 2 );
store listen ( origin = $SLAVE, provider = 2, receiver = 1 );
#创建一个复制集，id也是从1开始
create set ( id = $SET_ID, origin = $MASTER, comment = 'All pgbench tables' );
#向自己的复制集中添加表，每个需要复制的表添加一条set命令，id从1开始，逐次递加，步进为1
#fully qualified name是表的全称：模式名.表名
#这里的复制集id需要和前面创建的复制集id一致
set add table ( set id = $SET_ID, origin = $MASTER,
id = 1, fully qualified name = 'public.accounts',
comment = 'Table accounts' );

_EOF_

#执行初始化脚本，主从数据库都可以

[root@rhevm01 ~]# ./urt_replica_init.sh > slonyI-init.log &
[root@rhevm01 ~]# cat slonyI-init.log
<stdin>:27: waiting for event (1,5000000004) to be confirmed on node 2
<stdin>:27: waiting for event (1,5000000004) to be confirmed on node 2

#新建主数据库slon启动参数文件

[root@rhevm01 ~]# cat rhevm01.slon
cluster_name="URT"
conn_info="dbname=URT host=rhevm01.example.com port=5433 user=postgres password=**********"

#启动主数据库slon服务

[root@rhevm01 ~]# slon -f rhevm01.slon > rhevm01-startslon.log &

#查看主数据库slon启动日志

点击查看

2013-01-09 18:04:44 CST CONFIG main: slon version 2.1.2 starting up
2013-01-09 18:04:44 CST INFO   slon: watchdog process started
2013-01-09 18:04:44 CST CONFIG slon: watchdog ready - pid = 2092
2013-01-09 18:04:44 CST CONFIG slon: worker process created - pid = 2093
2013-01-09 18:04:44 CST CONFIG main: Integer option vac_frequency = 3
2013-01-09 18:04:44 CST CONFIG main: Integer option log_level = 0
2013-01-09 18:04:44 CST CONFIG main: Integer option sync_interval = 2000
2013-01-09 18:04:44 CST CONFIG main: Integer option sync_interval_timeout = 10000
2013-01-09 18:04:44 CST CONFIG main: Integer option sync_group_maxsize = 20
2013-01-09 18:04:44 CST CONFIG main: Integer option desired_sync_time = 60000
2013-01-09 18:04:44 CST CONFIG main: Integer option syslog = 0
2013-01-09 18:04:44 CST CONFIG main: Integer option quit_sync_provider = 0
2013-01-09 18:04:44 CST CONFIG main: Integer option sync_max_rowsize = 8192
2013-01-09 18:04:44 CST CONFIG main: Integer option sync_max_largemem = 5242880
2013-01-09 18:04:44 CST CONFIG main: Integer option remote_listen_timeout = 300
2013-01-09 18:04:44 CST CONFIG main: Integer option monitor_interval = 500
2013-01-09 18:04:44 CST CONFIG main: Integer option explain_interval = 0
2013-01-09 18:04:44 CST CONFIG main: Integer option tcp_keepalive_idle = 0
2013-01-09 18:04:44 CST CONFIG main: Integer option tcp_keepalive_interval = 0
2013-01-09 18:04:44 CST CONFIG main: Integer option tcp_keepalive_count = 0
2013-01-09 18:04:44 CST CONFIG main: Boolean option log_pid = 0
2013-01-09 18:04:44 CST CONFIG main: Boolean option log_timestamp = 1
2013-01-09 18:04:44 CST CONFIG main: Boolean option tcp_keepalive = 1
2013-01-09 18:04:44 CST CONFIG main: Boolean option monitor_threads = 1
2013-01-09 18:04:44 CST CONFIG main: Real option real_placeholder = 0.000000
2013-01-09 18:04:44 CST CONFIG main: String option cluster_name = URT
2013-01-09 18:04:44 CST CONFIG main: String option conn_info = dbname=URT host=rhevm01.example.com port=5433 user=postgres password=********
2013-01-09 18:04:44 CST CONFIG main: String option pid_file = [NULL]
2013-01-09 18:04:44 CST CONFIG main: String option log_timestamp_format = %Y-%m-%d %H:%M:%S %Z 
2013-01-09 18:04:44 CST CONFIG main: String option archive_dir = [NULL]
2013-01-09 18:04:44 CST CONFIG main: String option sql_on_connection = [NULL]
2013-01-09 18:04:44 CST CONFIG main: String option lag_interval = [NULL]
2013-01-09 18:04:44 CST CONFIG main: String option command_on_logarchive = [NULL]
2013-01-09 18:04:44 CST CONFIG main: String option syslog_facility = LOCAL0
2013-01-09 18:04:44 CST CONFIG main: String option syslog_ident = slon
2013-01-09 18:04:44 CST CONFIG main: String option cleanup_interval = 10 minutes
2013-01-09 18:04:44 CST CONFIG main: local node id = 1
2013-01-09 18:04:44 CST INFO   main: main process started
2013-01-09 18:04:44 CST CONFIG main: launching sched_start_mainloop
2013-01-09 18:04:44 CST CONFIG main: loading current cluster configuration
2013-01-09 18:04:44 CST CONFIG storeNode: no_id=2 no_comment='Slave Node'
2013-01-09 18:04:44 CST CONFIG storePath: pa_server=2 pa_client=1 pa_conninfo="dbname=URT host=rhevm02.example.com port=5433 user=postgres password=***********" pa_connretry=10
2013-01-09 18:04:44 CST CONFIG storeListen: li_origin=2 li_receiver=1 li_provider=2
2013-01-09 18:04:44 CST CONFIG main: last local event sequence = 5000000004
2013-01-09 18:04:44 CST CONFIG main: configuration complete - starting threads
2013-01-09 18:04:44 CST INFO   localListenThread: thread starts
2013-01-09 18:04:44 CST CONFIG version for "dbname=URT host=rhevm01.example.com port=5433 user=postgres password=***********" is 80411
2013-01-09 18:04:44 CST CONFIG enableNode: no_id=2
2013-01-09 18:04:44 CST INFO   remoteWorkerThread_2: thread starts
2013-01-09 18:04:44 CST CONFIG cleanupThread: thread starts
2013-01-09 18:04:44 CST INFO   main: running scheduler mainloop
2013-01-09 18:04:44 CST INFO   syncThread: thread starts
2013-01-09 18:04:44 CST CONFIG cleanupThread: bias = 35383
2013-01-09 18:04:44 CST INFO   monitorThread: thread starts
2013-01-09 18:04:44 CST INFO   remoteListenThread_2: thread starts
2013-01-09 18:04:44 CST CONFIG version for "dbname=URT host=rhevm01.example.com port=5433 user=postgres password=***********" is 80411
2013-01-09 18:04:44 CST CONFIG version for "dbname=URT host=rhevm01.example.com port=5433 user=postgres password=***********" is 80411
2013-01-09 18:04:44 CST CONFIG version for "dbname=URT host=rhevm01.example.com port=5433 user=postgres password=***********" is 80411
2013-01-09 18:04:44 CST CONFIG version for "dbname=URT host=rhevm01.example.com port=5433 user=postgres password=***********" is 80411
2013-01-09 18:04:44 CST CONFIG version for "dbname=URT host=rhevm02.example.com port=5433 user=postgres password=***********" is 80411
2013-01-09 18:04:44 CST CONFIG remoteWorkerThread_2: update provider configuration
2013-01-09 18:04:44 CST CONFIG storeListen: li_origin=2 li_receiver=1 li_provider=2
2013-01-09 18:04:44 CST CONFIG remoteWorkerThread_2: update provider configuration
2013-01-09 18:06:22 CST CONFIG storeSet: set_id=1 set_origin=1 set_comment='All pgbench tables'
2013-01-09 18:10:58 CST CONFIG storeListen: li_origin=2 li_receiver=1 li_provider=2
2013-01-09 18:10:58 CST CONFIG storeListen: li_origin=2 li_receiver=1 li_provider=2
2013-01-09 18:10:58 CST CONFIG remoteWorkerThread_2: update provider configuration
2013-01-09 18:15:52 CST INFO   cleanupThread:    0.014 seconds for cleanupEvent()
2013-01-09 18:27:14 CST INFO   cleanupThread:    0.024 seconds for cleanupEvent()
2013-01-09 18:38:12 CST INFO   cleanupThread:    0.006 seconds for cleanupEvent()
2013-01-09 18:38:12 CST INFO   cleanupThread:    0.013 seconds for vacuuming
2013-01-09 18:48:57 CST INFO   cleanupThread:    0.014 seconds for cleanupEvent()
2013-01-09 19:00:15 CST INFO   cleanupThread:    0.006 seconds for cleanupEvent()

#新建从数据库slon启动参数文件

[root@rhevm02 ~]# cat rhevm02.slon
cluster_name="URT"
conn_info="dbname=URT host=rhevm02.example.com port=5433 user=postgres password=**********"

#启动从数据库slon服务

[root@rhevm02 ~]# slon -f rhevm02.slon > rhevm02-startslon.log &

#查看从数据库slon启动日志

点击查看

2013-01-09 10:16:15 CST CONFIG main: slon version 2.1.2 starting up
2013-01-09 10:16:15 CST INFO   slon: watchdog process started
2013-01-09 10:16:15 CST CONFIG slon: watchdog ready - pid = 10797
2013-01-09 10:16:15 CST CONFIG slon: worker process created - pid = 10798
2013-01-09 10:16:15 CST CONFIG main: Integer option vac_frequency = 3
2013-01-09 10:16:15 CST CONFIG main: Integer option log_level = 0
2013-01-09 10:16:15 CST CONFIG main: Integer option sync_interval = 2000
2013-01-09 10:16:15 CST CONFIG main: Integer option sync_interval_timeout = 10000
2013-01-09 10:16:15 CST CONFIG main: Integer option sync_group_maxsize = 20
2013-01-09 10:16:15 CST CONFIG main: Integer option desired_sync_time = 60000
2013-01-09 10:16:15 CST CONFIG main: Integer option syslog = 0
2013-01-09 10:16:15 CST CONFIG main: Integer option quit_sync_provider = 0
2013-01-09 10:16:15 CST CONFIG main: Integer option sync_max_rowsize = 8192
2013-01-09 10:16:15 CST CONFIG main: Integer option sync_max_largemem = 5242880
2013-01-09 10:16:15 CST CONFIG main: Integer option remote_listen_timeout = 300
2013-01-09 10:16:15 CST CONFIG main: Integer option monitor_interval = 500
2013-01-09 10:16:15 CST CONFIG main: Integer option explain_interval = 0
2013-01-09 10:16:15 CST CONFIG main: Integer option tcp_keepalive_idle = 0
2013-01-09 10:16:15 CST CONFIG main: Integer option tcp_keepalive_interval = 0
2013-01-09 10:16:15 CST CONFIG main: Integer option tcp_keepalive_count = 0
2013-01-09 10:16:15 CST CONFIG main: Boolean option log_pid = 0
2013-01-09 10:16:15 CST CONFIG main: Boolean option log_timestamp = 1
2013-01-09 10:16:15 CST CONFIG main: Boolean option tcp_keepalive = 1
2013-01-09 10:16:15 CST CONFIG main: Boolean option monitor_threads = 1
2013-01-09 10:16:15 CST CONFIG main: Real option real_placeholder = 0.000000
2013-01-09 10:16:15 CST CONFIG main: String option cluster_name = URT
2013-01-09 10:16:15 CST CONFIG main: String option conn_info = dbname=URT host=rhevm02.example.com port=5433 user=postgres 

password=***********
2013-01-09 10:16:15 CST CONFIG main: String option pid_file = [NULL]
2013-01-09 10:16:15 CST CONFIG main: String option log_timestamp_format = %Y-%m-%d %H:%M:%S %Z 
2013-01-09 10:16:15 CST CONFIG main: String option archive_dir = [NULL]
2013-01-09 10:16:15 CST CONFIG main: String option sql_on_connection = [NULL]
2013-01-09 10:16:15 CST CONFIG main: String option lag_interval = [NULL]
2013-01-09 10:16:15 CST CONFIG main: String option command_on_logarchive = [NULL]
2013-01-09 10:16:15 CST CONFIG main: String option syslog_facility = LOCAL0
2013-01-09 10:16:15 CST CONFIG main: String option syslog_ident = slon
2013-01-09 10:16:15 CST CONFIG main: String option cleanup_interval = 10 minutes
2013-01-09 10:16:15 CST CONFIG main: local node id = 2
2013-01-09 10:16:15 CST INFO   main: main process started
2013-01-09 10:16:15 CST CONFIG main: launching sched_start_mainloop
2013-01-09 10:16:15 CST CONFIG main: loading current cluster configuration
2013-01-09 10:16:15 CST CONFIG storeNode: no_id=1 no_comment='Primary Node'
2013-01-09 10:16:15 CST CONFIG storePath: pa_server=1 pa_client=2 pa_conninfo="dbname=URT host=rhevm01.example.com port=5433 

user=postgres password=***********" pa_connretry=10
2013-01-09 10:16:15 CST CONFIG storeListen: li_origin=1 li_receiver=2 li_provider=1
2013-01-09 10:16:15 CST CONFIG main: last local event sequence = 5000000001
2013-01-09 10:16:15 CST CONFIG main: configuration complete - starting threads
2013-01-09 10:16:15 CST INFO   localListenThread: thread starts
2013-01-09 10:16:15 CST CONFIG version for "dbname=URT host=rhevm02.example.com port=5433 user=postgres password=***********" is 

80411
2013-01-09 10:16:15 CST CONFIG enableNode: no_id=1
2013-01-09 10:16:15 CST INFO   remoteWorkerThread_1: thread starts
2013-01-09 10:16:15 CST INFO   monitorThread: thread starts
2013-01-09 10:16:15 CST CONFIG cleanupThread: thread starts
2013-01-09 10:16:15 CST CONFIG cleanupThread: bias = 35383
2013-01-09 10:16:15 CST INFO   main: running scheduler mainloop
2013-01-09 10:16:15 CST INFO   syncThread: thread starts
2013-01-09 10:16:15 CST INFO   remoteListenThread_1: thread starts
2013-01-09 10:16:15 CST CONFIG version for "dbname=URT host=rhevm02.example.com port=5433 user=postgres password=***********" is 

80411
2013-01-09 10:16:15 CST CONFIG version for "dbname=URT host=rhevm02.example.com port=5433 user=postgres password=***********" is 

80411
2013-01-09 10:16:15 CST CONFIG version for "dbname=URT host=rhevm02.example.com port=5433 user=postgres password=***********" is 

80411
2013-01-09 10:16:15 CST CONFIG version for "dbname=URT host=rhevm01.example.com port=5433 user=postgres password=***********" is 

80411
2013-01-09 10:16:15 CST CONFIG version for "dbname=URT host=rhevm02.example.com port=5433 user=postgres password=***********" is 

80411
2013-01-09 10:16:15 CST CONFIG remoteWorkerThread_1: update provider configuration
2013-01-09 10:16:15 CST CONFIG storeListen: li_origin=1 li_receiver=2 li_provider=1
2013-01-09 10:16:15 CST CONFIG storeListen: li_origin=1 li_receiver=2 li_provider=1
2013-01-09 10:16:15 CST CONFIG storeListen: li_origin=1 li_receiver=2 li_provider=1
2013-01-09 10:16:15 CST CONFIG remoteWorkerThread_1: update provider configuration

#新建同步订阅脚本urt_replica_subscribe.sh

点击查看

[root@rhevm01 ~]# cat urt_replica_subscribe.sh 
#!/bin/sh
SLONIK=/usr/bin/slonik                      #slonik可执行文件位置
CLUSTER=URT                                 #集群名称
PORT=5433                                   #数据库连接端口
PWD=***********                             #密码
SET_ID=1                                    #复制集的名称
MASTER=1                                    #主服务器ID
HOST1=rhevm01.example.com                   #源库IP或主机名
DBNAME1=URT                                 #需要复制的源数据库
SLONY_USER=postgres                         #源库数据库超级用户名
SLAVE=2                                     #从服务器ID
HOST2=rhevm02.example.com                   #目的库IP或主机名
DBNAME2=URT                                 #需要复制的目的数据库
PGBENCH_USER=postgres                       #目的库用户名

$SLONIK <<_EOF_

cluster name = $CLUSTER;                    #定义集群名
#这两句是定义复制节点
node $MASTER admin conninfo = 'dbname=$DBNAME1 host=$HOST1 port=$PORT user=$SLONY_USER password=$PWD';
node $SLAVE admin conninfo = 'dbname=$DBNAME2 host=$HOST2 port=$PORT user=$PGBENCH_USER password=$PWD';
#提交复制集
subscribe set ( id = $SET_ID, provider = $MASTER, receiver = $SLAVE, forward = no);
_EOF_

#执行订阅脚本，主从数据库都可以

[root@rhevm01 ~]# ./urt_replica_subscribe.sh

#从数据库日志显示表被截断

[root@rhevm02 ~]# NOTICE:  truncate of "public"."accounts" succeeded

#主数据库slon会定时切换日志

2013-01-09 18:10:58 CST CONFIG remoteWorkerThread_2: update provider configuration

[root@rhevm01 ~]# NOTICE:  Slony-I: cleanup stale sl_nodelock entry for pid=6166
CONTEXT:  SQL statement "SELECT  "_URT".cleanupNodelock()"
PL/pgSQL function "cleanupevent" line 81 at PERFORM
NOTICE:  Slony-I: Logswitch to sl_log_2 initiated
CONTEXT:  SQL statement "SELECT  "_URT".logswitch_start()"
PL/pgSQL function "cleanupevent" line 95 at PERFORM
NOTICE:  Slony-I: log switch to sl_log_2 complete - truncate sl_log_1
CONTEXT:  PL/pgSQL function "cleanupevent" line 93 at assignment
[root@rhevm01 ~]# NOTICE:  Slony-I: Logswitch to sl_log_1 initiated
CONTEXT:  SQL statement "SELECT  "_URT".logswitch_start()"
PL/pgSQL function "cleanupevent" line 95 at PERFORM
NOTICE:  Slony-I: log switch to sl_log_1 complete - truncate sl_log_2
CONTEXT:  PL/pgSQL function "cleanupevent" line 93 at assignment

#从数据库slon会定时切换日志

2013-01-09 10:16:15 CST CONFIG remoteWorkerThread_1: update provider configuration
[root@rhevm02 ~]# NOTICE:  truncate of "public"."accounts" succeeded

[root@rhevm02 ~]# NOTICE:  Slony-I: Logswitch to sl_log_2 initiated
CONTEXT:  SQL statement "SELECT  "_URT".logswitch_start()"
PL/pgSQL function "cleanupevent" line 95 at PERFORM
[root@rhevm02 ~]# --NOTICE:  Slony-I: log switch to sl_log_2 complete - truncate sl_log_1
CONTEXT:  PL/pgSQL function "cleanupevent" line 93 at assignment
[root@rhevm02 ~]# NOTICE:  Slony-I: Logswitch to sl_log_1 initiated
CONTEXT:  SQL statement "SELECT  "_URT".logswitch_start()"
PL/pgSQL function "cleanupevent" line 95 at PERFORM
NOTICE:  Slony-I: log switch to sl_log_1 complete - truncate sl_log_2
CONTEXT:  PL/pgSQL function "cleanupevent" line 93 at assignment
NOTICE:  Slony-I: Logswitch to sl_log_2 initiated
CONTEXT:  SQL statement "SELECT  "_URT".logswitch_start()"
PL/pgSQL function "cleanupevent" line 95 at PERFORM
NOTICE:  Slony-I: log switch to sl_log_2 complete - truncate sl_log_1
CONTEXT:  PL/pgSQL function "cleanupevent" line 93 at assignment

#停止从数据库slon进程后，数据同步失效。再启动slon服务，数据同步成功（未同步的数据将被重新同步），附上日志记录

点击查看

[root@rhevm02 ~]# cat rhevm02.log
2013-01-09 14:33:47 CST CONFIG main: slon version 2.1.2 starting up
2013-01-09 14:33:47 CST INFO   slon: watchdog process started
2013-01-09 14:33:47 CST CONFIG slon: watchdog ready - pid = 21937
2013-01-09 14:33:47 CST CONFIG slon: worker process created - pid = 21938
2013-01-09 14:33:47 CST CONFIG main: Integer option vac_frequency = 3
2013-01-09 14:33:47 CST CONFIG main: Integer option log_level = 0
2013-01-09 14:33:47 CST CONFIG main: Integer option sync_interval = 2000
2013-01-09 14:33:47 CST CONFIG main: Integer option sync_interval_timeout = 10000
2013-01-09 14:33:47 CST CONFIG main: Integer option sync_group_maxsize = 20
2013-01-09 14:33:47 CST CONFIG main: Integer option desired_sync_time = 60000
2013-01-09 14:33:47 CST CONFIG main: Integer option syslog = 0
2013-01-09 14:33:47 CST CONFIG main: Integer option quit_sync_provider = 0
2013-01-09 14:33:47 CST CONFIG main: Integer option sync_max_rowsize = 8192
2013-01-09 14:33:47 CST CONFIG main: Integer option sync_max_largemem = 5242880
2013-01-09 14:33:47 CST CONFIG main: Integer option remote_listen_timeout = 300
2013-01-09 14:33:47 CST CONFIG main: Integer option monitor_interval = 500
2013-01-09 14:33:47 CST CONFIG main: Integer option explain_interval = 0
2013-01-09 14:33:47 CST CONFIG main: Integer option tcp_keepalive_idle = 0
2013-01-09 14:33:47 CST CONFIG main: Integer option tcp_keepalive_interval = 0
2013-01-09 14:33:47 CST CONFIG main: Integer option tcp_keepalive_count = 0
2013-01-09 14:33:47 CST CONFIG main: Boolean option log_pid = 0
2013-01-09 14:33:47 CST CONFIG main: Boolean option log_timestamp = 1
2013-01-09 14:33:47 CST CONFIG main: Boolean option tcp_keepalive = 1
2013-01-09 14:33:47 CST CONFIG main: Boolean option monitor_threads = 1
2013-01-09 14:33:47 CST CONFIG main: Real option real_placeholder = 0.000000
2013-01-09 14:33:47 CST CONFIG main: String option cluster_name = URT
2013-01-09 14:33:47 CST CONFIG main: String option conn_info = dbname=URT host=rhevm02.example.com port=5433 user=postgres password=***********
2013-01-09 14:33:47 CST CONFIG main: String option pid_file = [NULL]
2013-01-09 14:33:47 CST CONFIG main: String option log_timestamp_format = %Y-%m-%d %H:%M:%S %Z 
2013-01-09 14:33:47 CST CONFIG main: String option archive_dir = [NULL]
2013-01-09 14:33:47 CST CONFIG main: String option sql_on_connection = [NULL]
2013-01-09 14:33:47 CST CONFIG main: String option lag_interval = [NULL]
2013-01-09 14:33:47 CST CONFIG main: String option command_on_logarchive = [NULL]
2013-01-09 14:33:47 CST CONFIG main: String option syslog_facility = LOCAL0
2013-01-09 14:33:47 CST CONFIG main: String option syslog_ident = slon
2013-01-09 14:33:47 CST CONFIG main: String option cleanup_interval = 10 minutes
2013-01-09 14:33:47 CST CONFIG main: local node id = 2
2013-01-09 14:33:47 CST INFO   main: main process started
2013-01-09 14:33:47 CST CONFIG main: launching sched_start_mainloop
2013-01-09 14:33:47 CST CONFIG main: loading current cluster configuration
2013-01-09 14:33:47 CST CONFIG storeNode: no_id=1 no_comment='Primary Node'
2013-01-09 14:33:47 CST CONFIG storePath: pa_server=1 pa_client=2 pa_conninfo="dbname=URT host=rhevm01.example.com port=5433 user=postgres password=***********" pa_connretry=10
2013-01-09 14:33:47 CST CONFIG storeListen: li_origin=1 li_receiver=2 li_provider=1
2013-01-09 14:33:47 CST CONFIG storeSet: set_id=1 set_origin=1 set_comment='All pgbench tables'
2013-01-09 14:33:47 CST WARN   remoteWorker_wakeup: node 1 - no worker thread
2013-01-09 14:33:47 CST CONFIG storeSubscribe: sub_set=1 sub_provider=1 sub_forward='f'
2013-01-09 14:33:47 CST WARN   remoteWorker_wakeup: node 1 - no worker thread
2013-01-09 14:33:47 CST CONFIG enableSubscription: sub_set=1
2013-01-09 14:33:47 CST WARN   remoteWorker_wakeup: node 1 - no worker thread
2013-01-09 14:33:47 CST CONFIG main: last local event sequence = 5000001481
2013-01-09 14:33:47 CST CONFIG main: configuration complete - starting threads
2013-01-09 14:33:47 CST INFO   localListenThread: thread starts
2013-01-09 14:33:47 CST CONFIG version for "dbname=URT host=rhevm02.example.com port=5433 user=postgres password=***********" is 80411
2013-01-09 14:33:47 CST CONFIG enableNode: no_id=1
2013-01-09 14:33:47 CST INFO   remoteListenThread_1: thread starts
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: thread starts
2013-01-09 14:33:47 CST INFO   main: running scheduler mainloop
2013-01-09 14:33:47 CST CONFIG cleanupThread: thread starts
2013-01-09 14:33:47 CST CONFIG cleanupThread: bias = 35383
2013-01-09 14:33:47 CST INFO   syncThread: thread starts
2013-01-09 14:33:47 CST INFO   monitorThread: thread starts
2013-01-09 14:33:47 CST CONFIG version for "dbname=URT host=rhevm02.example.com port=5433 user=postgres password=***********" is 80411
2013-01-09 14:33:47 CST CONFIG version for "dbname=URT host=rhevm02.example.com port=5433 user=postgres password=***********" is 80411
2013-01-09 14:33:47 CST CONFIG version for "dbname=URT host=rhevm02.example.com port=5433 user=postgres password=***********" is 80411
2013-01-09 14:33:47 CST CONFIG version for "dbname=URT host=rhevm02.example.com port=5433 user=postgres password=***********" is 80411
2013-01-09 14:33:47 CST CONFIG version for "dbname=URT host=rhevm01.example.com port=5433 user=postgres password=***********" is 80411
2013-01-09 14:33:47 CST CONFIG remoteWorkerThread_1: update provider configuration
2013-01-09 14:33:47 CST CONFIG remoteWorkerThread_1: helper thread for provider 1 created
2013-01-09 14:33:47 CST CONFIG remoteWorkerThread_1: added active set 1 to provider 1
2013-01-09 14:33:47 CST CONFIG version for "dbname=URT host=rhevm01.example.com port=5433 user=postgres password=***********" is 80411
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: SYNC 5000001498 done in 0.022 seconds
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: SYNC 5000001501 done in 0.006 seconds
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: SYNC 5000001502 done in 0.007 seconds
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: SYNC 5000001503 done in 0.006 seconds
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: SYNC 5000001504 done in 0.006 seconds
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: SYNC 5000001505 done in 0.006 seconds
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: SYNC 5000001506 done in 0.006 seconds
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: SYNC 5000001507 done in 0.006 seconds
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: SYNC 5000001508 done in 0.006 seconds
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: SYNC 5000001509 done in 0.006 seconds
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: SYNC 5000001510 done in 0.005 seconds
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: SYNC 5000001511 done in 0.006 seconds
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: SYNC 5000001512 done in 0.005 seconds
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: SYNC 5000001513 done in 0.006 seconds
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: SYNC 5000001514 done in 0.006 seconds
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: SYNC 5000001515 done in 0.006 seconds
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: SYNC 5000001516 done in 0.005 seconds
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: SYNC 5000001517 done in 0.005 seconds
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: SYNC 5000001518 done in 0.005 seconds
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: SYNC 5000001519 done in 0.006 seconds
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: SYNC 5000001520 done in 0.006 seconds
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: SYNC 5000001521 done in 0.006 seconds
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: SYNC 5000001522 done in 0.006 seconds
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: SYNC 5000001523 done in 0.006 seconds
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: SYNC 5000001524 done in 0.006 seconds
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: SYNC 5000001525 done in 0.006 seconds
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: SYNC 5000001526 done in 0.006 seconds
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: SYNC 5000001527 done in 0.006 seconds
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: SYNC 5000001528 done in 0.006 seconds
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: SYNC 5000001529 done in 0.005 seconds
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: SYNC 5000001530 done in 0.006 seconds
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: SYNC 5000001531 done in 0.006 seconds
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: SYNC 5000001532 done in 0.005 seconds
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: SYNC 5000001533 done in 0.006 seconds
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: SYNC 5000001534 done in 0.006 seconds
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: SYNC 5000001535 done in 0.005 seconds
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: SYNC 5000001536 done in 0.005 seconds
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: SYNC 5000001537 done in 0.005 seconds
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: SYNC 5000001538 done in 0.005 seconds
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: SYNC 5000001539 done in 0.005 seconds
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: SYNC 5000001540 done in 0.005 seconds
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: SYNC 5000001541 done in 0.005 seconds
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: SYNC 5000001542 done in 0.005 seconds
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: SYNC 5000001543 done in 0.006 seconds
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: SYNC 5000001544 done in 0.006 seconds
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: SYNC 5000001545 done in 0.006 seconds
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: SYNC 5000001546 done in 0.006 seconds
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: SYNC 5000001547 done in 0.006 seconds
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: SYNC 5000001548 done in 0.005 seconds
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: SYNC 5000001549 done in 0.005 seconds
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: SYNC 5000001550 done in 0.006 seconds
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: SYNC 5000001551 done in 0.005 seconds
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: SYNC 5000001552 done in 0.005 seconds
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: SYNC 5000001553 done in 0.005 seconds
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: SYNC 5000001554 done in 0.005 seconds
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: SYNC 5000001555 done in 0.006 seconds
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: SYNC 5000001556 done in 0.005 seconds
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: SYNC 5000001557 done in 0.005 seconds
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: SYNC 5000001558 done in 0.005 seconds
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: SYNC 5000001559 done in 0.006 seconds
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: SYNC 5000001560 done in 0.006 seconds
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: SYNC 5000001561 done in 0.006 seconds
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: SYNC 5000001562 done in 0.006 seconds
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: SYNC 5000001563 done in 0.006 seconds
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: SYNC 5000001564 done in 0.005 seconds
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:33:47 CST INFO   remoteWorkerThread_1: SYNC 5000001565 done in 0.006 seconds
2013-01-09 14:33:55 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:33:55 CST INFO   remoteWorkerThread_1: SYNC 5000001566 done in 0.007 seconds
2013-01-09 14:34:03 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:34:03 CST INFO   remoteWorkerThread_1: SYNC 5000001567 done in 0.007 seconds
2013-01-09 14:34:11 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:34:11 CST INFO   remoteWorkerThread_1: SYNC 5000001568 done in 0.007 seconds
2013-01-09 14:34:29 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:34:29 CST INFO   remoteWorkerThread_1: SYNC 5000001569 done in 0.007 seconds
2013-01-09 14:34:31 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:34:31 CST INFO   remoteWorkerThread_1: SYNC 5000001570 done in 0.007 seconds
2013-01-09 14:34:49 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:34:49 CST INFO   remoteWorkerThread_1: SYNC 5000001571 done in 0.006 seconds
2013-01-09 14:34:51 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:34:51 CST INFO   remoteWorkerThread_1: SYNC 5000001572 done in 0.007 seconds
2013-01-09 14:35:09 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:35:09 CST INFO   remoteWorkerThread_1: SYNC 5000001573 done in 0.007 seconds
2013-01-09 14:35:11 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:35:11 CST INFO   remoteWorkerThread_1: SYNC 5000001574 done in 0.007 seconds
2013-01-09 14:35:29 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:35:29 CST INFO   remoteWorkerThread_1: SYNC 5000001575 done in 0.008 seconds
2013-01-09 14:35:31 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:35:31 CST INFO   remoteWorkerThread_1: SYNC 5000001576 done in 0.008 seconds
2013-01-09 14:35:49 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:35:49 CST INFO   remoteWorkerThread_1: SYNC 5000001577 done in 0.008 seconds
2013-01-09 14:35:51 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:35:51 CST INFO   remoteWorkerThread_1: SYNC 5000001578 done in 0.008 seconds
2013-01-09 14:36:09 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:36:09 CST INFO   remoteWorkerThread_1: SYNC 5000001579 done in 0.008 seconds
2013-01-09 14:36:11 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:36:11 CST INFO   remoteWorkerThread_1: SYNC 5000001580 done in 0.007 seconds
2013-01-09 14:36:29 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:36:29 CST INFO   remoteWorkerThread_1: SYNC 5000001581 done in 0.009 seconds
2013-01-09 14:36:31 CST INFO   remoteWorkerThread_1: syncing set 1 with 1 table(s) from provider 1
2013-01-09 14:36:31 CST INFO   remoteWorkerThread_1: SYNC 5000001582 done in 0.008 seconds

#ERROR_001 <stdin>:11: Error: namespace "_URT" already exists in database of node 1

URT=# drop SCHEMA "_URT" CASCADE;

posted on 2013-01-08 16:37 jackiedai 阅读(618) 评论(0) 收藏举报

刷新页面返回顶部

jackiedai

Slony-I同步复制配置

导航

公告