[pgcluster: 852] pg_dump実行時レプリケーションサーバが終了する件

2006年 2月 8日 (水) 14:31:26 JST

はじめまして。鈴木と申します。

過去にも同様の質問がありましたが、解決していない
ように見受けられたので、改めて質問させて下さい。

現在PGClusterを使って、レプリケーションの動作確認を
行っておりますが、pg_dumpをした時にレプリケーション
サーバが終了してしまいます。対処方法等ありましたら
ご教授下さい。または、バックアップを取得する他の方法
でもありましたら、教えていただけないでしょうか。

以下、構成と手順を示します。

[構成]
PGCluster 1.3.0c
OS: Red Hat Enterprise Linux ES3
カーネル: 2.4.21-37.ELsmp
レプリケーションサーバ×1台
　repl.mydomain
クラスタサーバ×3台
　db1.mydomain、db2.mydomain、db3.mydomain

[手順]
各サーバにてプロセスが立ち上がっている状態で、
db1から以下のコマンドを実行しました。
　$ pg_dump postgres > postgres.dmp
なお、postgresデータベースはcreatedb直後の状態です。
また、pg_dumpはうまく取れているようで、pg_dump直後に
レプリケーションサーバが終了しているように見えます。

少し長いですが、以下にpgreplicateのデバッグログをつけておきます。

======================================================================
pgreplicateデバッグログ
======================================================================
[postgres ＠ repl postgres]$ pgreplicate -D /usr/local/pgsql/etc -nv
DEBUG:replicate_main():replicate main 8001 port bind OK
DEBUG:PGRreplicate_packet_send():cmdSts=N
DEBUG:PGRreplicate_packet_send():cmdType=
DEBUG:PGRreplicate_packet_send():rlog=0
DEBUG:PGRreplicate_packet_send():request_id=0
DEBUG:PGRreplicate_packet_send():replicate_id=0
DEBUG:PGRreplicate_packet_send():port=0
DEBUG:PGRreplicate_packet_send():pid=0
DEBUG:PGRreplicate_packet_send():from_host=repl.mydomain
DEBUG:PGRreplicate_packet_send():dbName=template1
DEBUG:PGRreplicate_packet_send():userName=postgres
DEBUG:PGRreplicate_packet_send():recieve sec=0
DEBUG:PGRreplicate_packet_send():recieve usec=0
DEBUG:PGRreplicate_packet_send():query_size=79
DEBUG:PGRreplicate_packet_send():query=SELECT PGR_SYSTEM_COMMAND_FUNCTION(1,'repl.mydomain',8001,8101,8201)
DEBUG:sem_lock[1]
DEBUG:pgr_createConn():PQsetdbLogin host[db1.mydomain] port[5432] db[template1] user[postgres]
DEBUG:pgr_createConn():PQsetdbLogin host[db3.mydomain] port[5432] db[template1] user[postgres]
DEBUG:pgr_createConn():PQsetdbLogin host[db2.mydomain] port[5432] db[template1] user[postgres]
DEBUG:pgr_createConn():PQsetdbLogin ok
DEBUG:pgr_createConn():PQsetdbLogin ok
DEBUG:pgr_createConn():PQsetdbLogin ok
DEBUG:sem_unlock[1]

--------------------ここでpg_dumpを実行--------------------

DEBUG:replicate_loop():replicate_loop selected
DEBUG:PGRreplicate_packet_send():cmdSts=T
DEBUG:PGRreplicate_packet_send():cmdType=B
DEBUG:PGRreplicate_packet_send():rlog=0
DEBUG:PGRreplicate_packet_send():request_id=1
DEBUG:PGRreplicate_packet_send():replicate_id=0
DEBUG:PGRreplicate_packet_send():port=5432
DEBUG:PGRreplicate_packet_send():pid=25565
DEBUG:PGRreplicate_packet_send():from_host=db1.mydomain
DEBUG:PGRreplicate_packet_send():dbName=postgres
DEBUG:PGRreplicate_packet_send():userName=postgres
DEBUG:PGRreplicate_packet_send():recieve sec=1139372688
DEBUG:PGRreplicate_packet_send():recieve usec=314607
DEBUG:PGRreplicate_packet_send():query_size=5
DEBUG:PGRreplicate_packet_send():query=BEGIN
DEBUG:sem_lock[1]
DEBUG:PGRreturn_result():PGRreturn_result[3,1139372688,314607,1,1]
DEBUG:PGRreturn_result():wait for answer
DEBUG:pgr_createConn():PQsetdbLogin host[db2.mydomain] port[5432] db[postgres] user[postgres]
DEBUG:pgr_createConn():PQsetdbLogin host[db3.mydomain] port[5432] db[postgres] user[postgres]
DEBUG:answer[PGR_QUERY_DONE_NOTICE_CMD]
DEBUG:read_answer():QUERY DONE
DEBUG:PGRreturn_result():status of PGRreturn_result[0]
DEBUG:pgr_createConn():PQsetdbLogin ok
DEBUG:send_sync_data():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1139372688,314607,1,1) )
DEBUG:pgr_createConn():PQsetdbLogin ok
DEBUG:send_sync_data():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1139372688,314607,1,1) )
DEBUG:sem_unlock[1]
DEBUG:replicate_loop():replicate_loop selected
DEBUG:PGRreplicate_packet_send():cmdSts=T
DEBUG:PGRreplicate_packet_send():cmdType=T
DEBUG:PGRreplicate_packet_send():rlog=0
DEBUG:PGRreplicate_packet_send():request_id=2
DEBUG:PGRreplicate_packet_send():replicate_id=0
DEBUG:PGRreplicate_packet_send():port=5432
DEBUG:PGRreplicate_packet_send():pid=25565
DEBUG:PGRreplicate_packet_send():from_host=db1.mydomain
DEBUG:PGRreplicate_packet_send():dbName=postgres
DEBUG:PGRreplicate_packet_send():userName=postgres
DEBUG:PGRreplicate_packet_send():recieve sec=1139372688
DEBUG:PGRreplicate_packet_send():recieve usec=328841
DEBUG:PGRreplicate_packet_send():query_size=44
DEBUG:PGRreplicate_packet_send():query=SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
DEBUG:sem_lock[1]
DEBUG:PGRreturn_result():PGRreturn_result[]
DEBUG:PGRreturn_result():wait for answer
DEBUG:send_sync_data():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1139372688,328841,1,1) )
DEBUG:send_sync_data():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1139372688,328841,1,1) )
DEBUG:answer[PGR_QUERY_DONE_NOTICE_CMD]
DEBUG:read_answer():QUERY DONE
DEBUG:PGRreturn_result():status of PGRreturn_result[0]
DEBUG:sem_unlock[1]
DEBUG:replicate_loop():replicate_loop selected
DEBUG:PGRreplicate_packet_send():cmdSts=T
DEBUG:PGRreplicate_packet_send():cmdType=T
DEBUG:PGRreplicate_packet_send():rlog=0
DEBUG:PGRreplicate_packet_send():request_id=3
DEBUG:PGRreplicate_packet_send():replicate_id=0
DEBUG:PGRreplicate_packet_send():port=5432
DEBUG:PGRreplicate_packet_send():pid=25565
DEBUG:PGRreplicate_packet_send():from_host=db1.mydomain
DEBUG:PGRreplicate_packet_send():dbName=postgres
DEBUG:PGRreplicate_packet_send():userName=postgres
DEBUG:PGRreplicate_packet_send():recieve sec=1139372688
DEBUG:PGRreplicate_packet_send():recieve usec=333712
DEBUG:PGRreplicate_packet_send():query_size=19
DEBUG:PGRreplicate_packet_send():query=SET DATESTYLE = ISO
DEBUG:sem_lock[1]
DEBUG:PGRreturn_result():PGRreturn_result[]
DEBUG:PGRreturn_result():wait for answer
DEBUG:send_sync_data():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1139372688,333712,1,1) )
DEBUG:send_sync_data():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1139372688,333712,1,1) )
DEBUG:answer[PGR_QUERY_DONE_NOTICE_CMD]
DEBUG:read_answer():QUERY DONE
DEBUG:PGRreturn_result():status of PGRreturn_result[0]
DEBUG:sem_unlock[1]
DEBUG:replicate_loop():replicate_loop selected
DEBUG:PGRreplicate_packet_send():cmdSts=T
DEBUG:PGRreplicate_packet_send():cmdType=T
DEBUG:PGRreplicate_packet_send():rlog=0
DEBUG:PGRreplicate_packet_send():request_id=4
DEBUG:PGRreplicate_packet_send():replicate_id=0
DEBUG:PGRreplicate_packet_send():port=5432
DEBUG:PGRreplicate_packet_send():pid=25565
DEBUG:PGRreplicate_packet_send():from_host=db1.mydomain
DEBUG:PGRreplicate_packet_send():dbName=postgres
DEBUG:PGRreplicate_packet_send():userName=postgres
DEBUG:PGRreplicate_packet_send():recieve sec=1139372688
DEBUG:PGRreplicate_packet_send():recieve usec=339245
DEBUG:PGRreplicate_packet_send():query_size=27
DEBUG:PGRreplicate_packet_send():query=SET extra_float_digits TO 2
DEBUG:sem_lock[1]
DEBUG:PGRreturn_result():PGRreturn_result[]
DEBUG:PGRreturn_result():wait for answer
DEBUG:send_sync_data():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1139372688,339245,1,1) )
DEBUG:send_sync_data():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1139372688,339245,1,1) )
DEBUG:answer[PGR_QUERY_DONE_NOTICE_CMD]
DEBUG:read_answer():QUERY DONE
DEBUG:PGRreturn_result():status of PGRreturn_result[0]
DEBUG:sem_unlock[1]
DEBUG:replicate_loop():replicate_loop selected
DEBUG:PGRreplicate_packet_send():cmdSts=T
DEBUG:PGRreplicate_packet_send():cmdType=T
DEBUG:PGRreplicate_packet_send():rlog=0
DEBUG:PGRreplicate_packet_send():request_id=5
DEBUG:PGRreplicate_packet_send():replicate_id=0
DEBUG:PGRreplicate_packet_send():port=5432
DEBUG:PGRreplicate_packet_send():pid=25565
DEBUG:PGRreplicate_packet_send():from_host=db1.mydomain
DEBUG:PGRreplicate_packet_send():dbName=postgres
DEBUG:PGRreplicate_packet_send():userName=postgres
DEBUG:PGRreplicate_packet_send():recieve sec=1139372688
DEBUG:PGRreplicate_packet_send():recieve usec=344108
DEBUG:PGRreplicate_packet_send():query_size=28
DEBUG:PGRreplicate_packet_send():query=SET search_path = pg_catalog
DEBUG:sem_lock[1]
DEBUG:PGRreturn_result():PGRreturn_result[]
DEBUG:PGRreturn_result():wait for answer
DEBUG:send_sync_data():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1139372688,344108,1,1) )
DEBUG:send_sync_data():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1139372688,344108,1,1) )
DEBUG:answer[PGR_QUERY_DONE_NOTICE_CMD]
DEBUG:read_answer():QUERY DONE
DEBUG:PGRreturn_result():status of PGRreturn_result[0]
DEBUG:sem_unlock[1]
DEBUG:replicate_loop():replicate_loop selected
DEBUG:PGRreplicate_packet_send():cmdSts=T
DEBUG:PGRreplicate_packet_send():cmdType=S
DEBUG:PGRreplicate_packet_send():rlog=0
DEBUG:PGRreplicate_packet_send():request_id=6
DEBUG:PGRreplicate_packet_send():replicate_id=0
DEBUG:PGRreplicate_packet_send():port=5432
DEBUG:PGRreplicate_packet_send():pid=25565
DEBUG:PGRreplicate_packet_send():from_host=db1.mydomain
DEBUG:PGRreplicate_packet_send():dbName=postgres
DEBUG:PGRreplicate_packet_send():userName=postgres
DEBUG:PGRreplicate_packet_send():recieve sec=1139372688
DEBUG:PGRreplicate_packet_send():recieve usec=349221
DEBUG:PGRreplicate_packet_send():query_size=123
DEBUG:PGRreplicate_packet_send():query=SELECT tableoid, oid, nspname, (select usename from pg_user where nspowner = usesysid) as usename, nspacl FROM pg_namespace
DEBUG:sem_lock[1]
DEBUG:PGRreturn_result():PGRreturn_result[]
DEBUG:PGRreturn_result():wait for answer
DEBUG:send_sync_data():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1139372688,349221,1,1) )
DEBUG:send_sync_data():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1139372688,349221,1,1) )
DEBUG:answer[PGR_QUERY_DONE_NOTICE_CMD]
DEBUG:read_answer():QUERY DONE
DEBUG:PGRreturn_result():status of PGRreturn_result[0]
DEBUG:sem_unlock[1]
DEBUG:replicate_loop():replicate_loop selected
DEBUG:PGRreplicate_packet_send():cmdSts=T
DEBUG:PGRreplicate_packet_send():cmdType=S
DEBUG:PGRreplicate_packet_send():rlog=0
DEBUG:PGRreplicate_packet_send():request_id=7
DEBUG:PGRreplicate_packet_send():replicate_id=0
DEBUG:PGRreplicate_packet_send():port=5432
DEBUG:PGRreplicate_packet_send():pid=25565
DEBUG:PGRreplicate_packet_send():from_host=db1.mydomain
DEBUG:PGRreplicate_packet_send():dbName=postgres
DEBUG:PGRreplicate_packet_send():userName=postgres
DEBUG:PGRreplicate_packet_send():recieve sec=1139372688
DEBUG:PGRreplicate_packet_send():recieve usec=358129
DEBUG:PGRreplicate_packet_send():query_size=275
DEBUG:PGRreplicate_packet_send():query=SELECT tableoid, oid, proname, prolang, pronargs, proargtypes, prorettype, proacl, pronamespace, (select usename from pg_user where proowner = usesysid) as usename FROM pg_proc WHERE NOT proisagg AND pronamespace != (select oid from pg_namespace where nspname = 'pg_catalog')
DEBUG:sem_lock[1]
DEBUG:PGRreturn_result():PGRreturn_result[]
DEBUG:PGRreturn_result():wait for answer
DEBUG:send_sync_data():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1139372688,358129,1,1) )
DEBUG:send_sync_data():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1139372688,358129,1,1) )
DEBUG:answer[PGR_QUERY_DONE_NOTICE_CMD]
DEBUG:read_answer():QUERY DONE
DEBUG:PGRreturn_result():status of PGRreturn_result[0]
DEBUG:sem_unlock[1]
DEBUG:replicate_loop():replicate_loop selected
DEBUG:PGRreplicate_packet_send():cmdSts=T
DEBUG:PGRreplicate_packet_send():cmdType=S
DEBUG:PGRreplicate_packet_send():rlog=0
DEBUG:PGRreplicate_packet_send():request_id=8
DEBUG:PGRreplicate_packet_send():replicate_id=0
DEBUG:PGRreplicate_packet_send():port=5432
DEBUG:PGRreplicate_packet_send():pid=25565
DEBUG:PGRreplicate_packet_send():from_host=db1.mydomain
DEBUG:PGRreplicate_packet_send():dbName=postgres
DEBUG:PGRreplicate_packet_send():userName=postgres
DEBUG:PGRreplicate_packet_send():recieve sec=1139372688
DEBUG:PGRreplicate_packet_send():recieve usec=367870
DEBUG:PGRreplicate_packet_send():query_size=338
DEBUG:PGRreplicate_packet_send():query=SELECT tableoid, oid, typname, typnamespace, (select usename from pg_user where typowner = usesysid) as usename, typinput::oid as typinput, typoutput::oid as typoutput, typelem, typrelid, CASE WHEN typrelid = 0 THEN ' '::"char" ELSE (SELECT relkind FROM pg_class WHERE oid = typrelid) END as typrelkind, typtype, typisdefined FROM pg_type
DEBUG:sem_lock[1]
DEBUG:PGRreturn_result():PGRreturn_result[]
DEBUG:PGRreturn_result():wait for answer
DEBUG:send_sync_data():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1139372688,367870,1,1) )
DEBUG:send_sync_data():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1139372688,367870,1,1) )
DEBUG:answer[PGR_QUERY_DONE_NOTICE_CMD]
DEBUG:read_answer():QUERY DONE
DEBUG:PGRreturn_result():status of PGRreturn_result[0]
DEBUG:sem_unlock[1]
DEBUG:replicate_loop():replicate_loop selected
DEBUG:PGRreplicate_packet_send():cmdSts=T
DEBUG:PGRreplicate_packet_send():cmdType=T
DEBUG:PGRreplicate_packet_send():rlog=0
DEBUG:PGRreplicate_packet_send():request_id=9
DEBUG:PGRreplicate_packet_send():replicate_id=0
DEBUG:PGRreplicate_packet_send():port=5432
DEBUG:PGRreplicate_packet_send():pid=25565
DEBUG:PGRreplicate_packet_send():from_host=db1.mydomain
DEBUG:PGRreplicate_packet_send():dbName=postgres
DEBUG:PGRreplicate_packet_send():userName=postgres
DEBUG:PGRreplicate_packet_send():recieve sec=1139372688
DEBUG:PGRreplicate_packet_send():recieve usec=392900
DEBUG:PGRreplicate_packet_send():query_size=48
DEBUG:PGRreplicate_packet_send():query=SET search_path = information_schema, pg_catalog
DEBUG:sem_lock[1]
DEBUG:PGRreturn_result():PGRreturn_result[]
DEBUG:PGRreturn_result():wait for answer
DEBUG:send_sync_data():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1139372688,392900,1,1) )
DEBUG:send_sync_data():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1139372688,392900,1,1) )
DEBUG:answer[PGR_QUERY_DONE_NOTICE_CMD]
DEBUG:read_answer():QUERY DONE
DEBUG:PGRreturn_result():status of PGRreturn_result[0]
DEBUG:sem_unlock[1]
DEBUG:replicate_loop():replicate_loop selected
DEBUG:PGRreplicate_packet_send():cmdSts=T
DEBUG:PGRreplicate_packet_send():cmdType=S
DEBUG:PGRreplicate_packet_send():rlog=0
DEBUG:PGRreplicate_packet_send():request_id=10
DEBUG:PGRreplicate_packet_send():replicate_id=0
DEBUG:PGRreplicate_packet_send():port=5432
DEBUG:PGRreplicate_packet_send():pid=25565
DEBUG:PGRreplicate_packet_send():from_host=db1.mydomain
DEBUG:PGRreplicate_packet_send():dbName=postgres
DEBUG:PGRreplicate_packet_send():userName=postgres
DEBUG:PGRreplicate_packet_send():recieve sec=1139372688
DEBUG:PGRreplicate_packet_send():recieve usec=398565
DEBUG:PGRreplicate_packet_send():query_size=165
DEBUG:PGRreplicate_packet_send():query=SELECT tableoid, oid, conname, pg_catalog.pg_get_constraintdef(oid) AS consrc FROM pg_catalog.pg_constraint WHERE contypid = '17069'::pg_catalog.oid ORDER BY conname
DEBUG:sem_lock[1]
DEBUG:PGRreturn_result():PGRreturn_result[]
DEBUG:PGRreturn_result():wait for answer
DEBUG:send_sync_data():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1139372688,398565,1,1) )
DEBUG:send_sync_data():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1139372688,398565,1,1) )
DEBUG:answer[PGR_QUERY_DONE_NOTICE_CMD]
DEBUG:read_answer():QUERY DONE
DEBUG:PGRreturn_result():status of PGRreturn_result[0]
DEBUG:sem_unlock[1]
DEBUG:replicate_loop():replicate_loop selected
DEBUG:PGRreplicate_packet_send():cmdSts=T
DEBUG:PGRreplicate_packet_send():cmdType=S
DEBUG:PGRreplicate_packet_send():rlog=0
DEBUG:PGRreplicate_packet_send():request_id=11
DEBUG:PGRreplicate_packet_send():replicate_id=0
DEBUG:PGRreplicate_packet_send():port=5432
DEBUG:PGRreplicate_packet_send():pid=25565
DEBUG:PGRreplicate_packet_send():from_host=db1.mydomain
DEBUG:PGRreplicate_packet_send():dbName=postgres
DEBUG:PGRreplicate_packet_send():userName=postgres
DEBUG:PGRreplicate_packet_send():recieve sec=1139372688
DEBUG:PGRreplicate_packet_send():recieve usec=406624
DEBUG:PGRreplicate_packet_send():query_size=165
DEBUG:PGRreplicate_packet_send():query=SELECT tableoid, oid, conname, pg_catalog.pg_get_constraintdef(oid) AS consrc FROM pg_catalog.pg_constraint WHERE contypid = '17071'::pg_catalog.oid ORDER BY conname
DEBUG:sem_lock[1]
DEBUG:PGRreturn_result():PGRreturn_result[]
DEBUG:PGRreturn_result():wait for answer
DEBUG:send_sync_data():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1139372688,406624,1,1) )
DEBUG:send_sync_data():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1139372688,406624,1,1) )
DEBUG:answer[PGR_QUERY_DONE_NOTICE_CMD]
DEBUG:read_answer():QUERY DONE
DEBUG:PGRreturn_result():status of PGRreturn_result[0]
DEBUG:sem_unlock[1]
DEBUG:replicate_loop():replicate_loop selected
DEBUG:PGRreplicate_packet_send():cmdSts=T
DEBUG:PGRreplicate_packet_send():cmdType=S
DEBUG:PGRreplicate_packet_send():rlog=0
DEBUG:PGRreplicate_packet_send():request_id=12
DEBUG:PGRreplicate_packet_send():replicate_id=0
DEBUG:PGRreplicate_packet_send():port=5432
DEBUG:PGRreplicate_packet_send():pid=25565
DEBUG:PGRreplicate_packet_send():from_host=db1.mydomain
DEBUG:PGRreplicate_packet_send():dbName=postgres
DEBUG:PGRreplicate_packet_send():userName=postgres
DEBUG:PGRreplicate_packet_send():recieve sec=1139372688
DEBUG:PGRreplicate_packet_send():recieve usec=412067
DEBUG:PGRreplicate_packet_send():query_size=165
DEBUG:PGRreplicate_packet_send():query=SELECT tableoid, oid, conname, pg_catalog.pg_get_constraintdef(oid) AS consrc FROM pg_catalog.pg_constraint WHERE contypid = '17072'::pg_catalog.oid ORDER BY conname
DEBUG:sem_lock[1]
DEBUG:PGRreturn_result():PGRreturn_result[]
DEBUG:PGRreturn_result():wait for answer
DEBUG:send_sync_data():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1139372688,412067,1,1) )
DEBUG:send_sync_data():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1139372688,412067,1,1) )
DEBUG:answer[PGR_QUERY_DONE_NOTICE_CMD]
DEBUG:read_answer():QUERY DONE
DEBUG:PGRreturn_result():status of PGRreturn_result[0]
DEBUG:sem_unlock[1]
DEBUG:replicate_loop():replicate_loop selected
DEBUG:PGRreplicate_packet_send():cmdSts=T
DEBUG:PGRreplicate_packet_send():cmdType=S
DEBUG:PGRreplicate_packet_send():rlog=0
DEBUG:PGRreplicate_packet_send():request_id=13
DEBUG:PGRreplicate_packet_send():replicate_id=0
DEBUG:PGRreplicate_packet_send():port=5432
DEBUG:PGRreplicate_packet_send():pid=25565
DEBUG:PGRreplicate_packet_send():from_host=db1.mydomain
DEBUG:PGRreplicate_packet_send():dbName=postgres
DEBUG:PGRreplicate_packet_send():userName=postgres
DEBUG:PGRreplicate_packet_send():recieve sec=1139372688
DEBUG:PGRreplicate_packet_send():recieve usec=417921
DEBUG:PGRreplicate_packet_send():query_size=165
DEBUG:PGRreplicate_packet_send():query=SELECT tableoid, oid, conname, pg_catalog.pg_get_constraintdef(oid) AS consrc FROM pg_catalog.pg_constraint WHERE contypid = '17076'::pg_catalog.oid ORDER BY conname
DEBUG:sem_lock[1]
DEBUG:PGRreturn_result():PGRreturn_result[]
DEBUG:PGRreturn_result():wait for answer
DEBUG:send_sync_data():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1139372688,417921,1,1) )
DEBUG:send_sync_data():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1139372688,417921,1,1) )
DEBUG:answer[PGR_QUERY_DONE_NOTICE_CMD]
DEBUG:read_answer():QUERY DONE
DEBUG:PGRreturn_result():status of PGRreturn_result[0]
DEBUG:sem_unlock[1]
DEBUG:replicate_loop():replicate_loop selected
DEBUG:PGRreplicate_packet_send():cmdSts=T
DEBUG:PGRreplicate_packet_send():cmdType=T
DEBUG:PGRreplicate_packet_send():rlog=0
DEBUG:PGRreplicate_packet_send():request_id=14
DEBUG:PGRreplicate_packet_send():replicate_id=0
DEBUG:PGRreplicate_packet_send():port=5432
DEBUG:PGRreplicate_packet_send():pid=25565
DEBUG:PGRreplicate_packet_send():from_host=db1.mydomain
DEBUG:PGRreplicate_packet_send():dbName=postgres
DEBUG:PGRreplicate_packet_send():userName=postgres
DEBUG:PGRreplicate_packet_send():recieve sec=1139372688
DEBUG:PGRreplicate_packet_send():recieve usec=423587
DEBUG:PGRreplicate_packet_send():query_size=28
DEBUG:PGRreplicate_packet_send():query=SET search_path = pg_catalog
DEBUG:sem_lock[1]
DEBUG:PGRreturn_result():PGRreturn_result[]
DEBUG:PGRreturn_result():wait for answer
DEBUG:send_sync_data():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1139372688,423587,1,1) )
DEBUG:send_sync_data():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1139372688,423587,1,1) )
DEBUG:answer[PGR_QUERY_DONE_NOTICE_CMD]
DEBUG:read_answer():QUERY DONE
DEBUG:PGRreturn_result():status of PGRreturn_result[0]
DEBUG:sem_unlock[1]
DEBUG:replicate_loop():replicate_loop selected
DEBUG:PGRreplicate_packet_send():cmdSts=T
DEBUG:PGRreplicate_packet_send():cmdType=S
DEBUG:PGRreplicate_packet_send():rlog=0
DEBUG:PGRreplicate_packet_send():request_id=15
DEBUG:PGRreplicate_packet_send():replicate_id=0
DEBUG:PGRreplicate_packet_send():port=5432
DEBUG:PGRreplicate_packet_send():pid=25565
DEBUG:PGRreplicate_packet_send():from_host=db1.mydomain
DEBUG:PGRreplicate_packet_send():dbName=postgres
DEBUG:PGRreplicate_packet_send():userName=postgres
DEBUG:PGRreplicate_packet_send():recieve sec=1139372688
DEBUG:PGRreplicate_packet_send():recieve usec=636941
DEBUG:PGRreplicate_packet_send():query_size=67
DEBUG:PGRreplicate_packet_send():query=SELECT tableoid, oid, * FROM pg_language WHERE lanispl ORDER BY oid
DEBUG:sem_lock[1]
DEBUG:PGRreturn_result():PGRreturn_result[]
DEBUG:PGRreturn_result():wait for answer
DEBUG:send_sync_data():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1139372688,636941,1,1) )
DEBUG:send_sync_data():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1139372688,636941,1,1) )
DEBUG:answer[PGR_QUERY_DONE_NOTICE_CMD]
DEBUG:read_answer():QUERY DONE
DEBUG:PGRreturn_result():status of PGRreturn_result[0]
DEBUG:sem_unlock[1]
DEBUG:replicate_loop():replicate_loop selected
DEBUG:PGRreplicate_packet_send():cmdSts=T
DEBUG:PGRreplicate_packet_send():cmdType=S
DEBUG:PGRreplicate_packet_send():rlog=0
DEBUG:PGRreplicate_packet_send():request_id=16
DEBUG:PGRreplicate_packet_send():replicate_id=0
DEBUG:PGRreplicate_packet_send():port=5432
DEBUG:PGRreplicate_packet_send():pid=25565
DEBUG:PGRreplicate_packet_send():from_host=db1.mydomain
DEBUG:PGRreplicate_packet_send():dbName=postgres
DEBUG:PGRreplicate_packet_send():userName=postgres
DEBUG:PGRreplicate_packet_send():recieve sec=1139372688
DEBUG:PGRreplicate_packet_send():recieve usec=643614
DEBUG:PGRreplicate_packet_send():query_size=295
DEBUG:PGRreplicate_packet_send():query=SELECT tableoid, oid, proname as aggname, pronamespace as aggnamespace, proargtypes[0] as aggbasetype, (select usename from pg_user where proowner = usesysid) as usename, proacl as aggacl FROM pg_proc WHERE proisagg AND pronamespace != (select oid from pg_namespace where nspname = 'pg_catalog')
DEBUG:sem_lock[1]
DEBUG:PGRreturn_result():PGRreturn_result[]
DEBUG:PGRreturn_result():wait for answer
DEBUG:send_sync_data():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1139372688,643614,1,1) )
DEBUG:send_sync_data():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1139372688,643614,1,1) )
DEBUG:answer[PGR_QUERY_DONE_NOTICE_CMD]
DEBUG:read_answer():QUERY DONE
DEBUG:PGRreturn_result():status of PGRreturn_result[0]
DEBUG:sem_unlock[1]
DEBUG:replicate_loop():replicate_loop selected
DEBUG:PGRreplicate_packet_send():cmdSts=T
DEBUG:PGRreplicate_packet_send():cmdType=S
DEBUG:PGRreplicate_packet_send():rlog=0
DEBUG:PGRreplicate_packet_send():request_id=17
DEBUG:PGRreplicate_packet_send():replicate_id=0
DEBUG:PGRreplicate_packet_send():port=5432
DEBUG:PGRreplicate_packet_send():pid=25565
DEBUG:PGRreplicate_packet_send():from_host=db1.mydomain
DEBUG:PGRreplicate_packet_send():dbName=postgres
DEBUG:PGRreplicate_packet_send():userName=postgres
DEBUG:PGRreplicate_packet_send():recieve sec=1139372688
DEBUG:PGRreplicate_packet_send():recieve usec=650199
DEBUG:PGRreplicate_packet_send():query_size=153
DEBUG:PGRreplicate_packet_send():query=SELECT tableoid, oid, oprname, oprnamespace, (select usename from pg_user where oprowner = usesysid) as usename, oprcode::oid as oprcode FROM pg_operator
DEBUG:sem_lock[1]
DEBUG:PGRreturn_result():PGRreturn_result[]
DEBUG:PGRreturn_result():wait for answer
DEBUG:send_sync_data():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1139372688,650199,1,1) )
DEBUG:send_sync_data():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1139372688,650199,1,1) )
DEBUG:answer[PGR_QUERY_DONE_NOTICE_CMD]
DEBUG:read_answer():QUERY DONE
DEBUG:PGRreturn_result():status of PGRreturn_result[0]
DEBUG:sem_unlock[1]
DEBUG:replicate_loop():replicate_loop selected
DEBUG:PGRreplicate_packet_send():cmdSts=T
DEBUG:PGRreplicate_packet_send():cmdType=S
DEBUG:PGRreplicate_packet_send():rlog=0
DEBUG:PGRreplicate_packet_send():request_id=18
DEBUG:PGRreplicate_packet_send():replicate_id=0
DEBUG:PGRreplicate_packet_send():port=5432
DEBUG:PGRreplicate_packet_send():pid=25565
DEBUG:PGRreplicate_packet_send():from_host=db1.mydomain
DEBUG:PGRreplicate_packet_send():dbName=postgres
DEBUG:PGRreplicate_packet_send():userName=postgres
DEBUG:PGRreplicate_packet_send():recieve sec=1139372688
DEBUG:PGRreplicate_packet_send():recieve usec=680796
DEBUG:PGRreplicate_packet_send():query_size=127
DEBUG:PGRreplicate_packet_send():query=SELECT tableoid, oid, opcname, opcnamespace, (select usename from pg_user where opcowner = usesysid) as usename FROM pg_opclass
DEBUG:sem_lock[1]
DEBUG:PGRreturn_result():PGRreturn_result[]
DEBUG:PGRreturn_result():wait for answer
DEBUG:send_sync_data():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1139372688,680796,1,1) )
DEBUG:send_sync_data():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1139372688,680796,1,1) )
DEBUG:answer[PGR_QUERY_DONE_NOTICE_CMD]
DEBUG:read_answer():QUERY DONE
DEBUG:PGRreturn_result():status of PGRreturn_result[0]
DEBUG:sem_unlock[1]
DEBUG:replicate_loop():replicate_loop selected
DEBUG:PGRreplicate_packet_send():cmdSts=T
DEBUG:PGRreplicate_packet_send():cmdType=S
DEBUG:PGRreplicate_packet_send():rlog=0
DEBUG:PGRreplicate_packet_send():request_id=19
DEBUG:PGRreplicate_packet_send():replicate_id=0
DEBUG:PGRreplicate_packet_send():port=5432
DEBUG:PGRreplicate_packet_send():pid=25565
DEBUG:PGRreplicate_packet_send():from_host=db1.mydomain
DEBUG:PGRreplicate_packet_send():dbName=postgres
DEBUG:PGRreplicate_packet_send():userName=postgres
DEBUG:PGRreplicate_packet_send():recieve sec=1139372688
DEBUG:PGRreplicate_packet_send():recieve usec=689301
DEBUG:PGRreplicate_packet_send():query_size=130
DEBUG:PGRreplicate_packet_send():query=SELECT tableoid, oid, conname, connamespace, (select usename from pg_user where conowner = usesysid) as usename FROM pg_conversion
DEBUG:sem_lock[1]
DEBUG:PGRreturn_result():PGRreturn_result[]
DEBUG:PGRreturn_result():wait for answer
DEBUG:send_sync_data():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1139372688,689301,1,1) )
DEBUG:send_sync_data():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1139372688,689301,1,1) )
DEBUG:answer[PGR_QUERY_DONE_NOTICE_CMD]
DEBUG:read_answer():QUERY DONE
DEBUG:PGRreturn_result():status of PGRreturn_result[0]
DEBUG:sem_unlock[1]
DEBUG:replicate_loop():replicate_loop selected
DEBUG:PGRreplicate_packet_send():cmdSts=T
DEBUG:PGRreplicate_packet_send():cmdType=S
DEBUG:PGRreplicate_packet_send():rlog=0
DEBUG:PGRreplicate_packet_send():request_id=20
DEBUG:PGRreplicate_packet_send():replicate_id=0
DEBUG:PGRreplicate_packet_send():port=5432
DEBUG:PGRreplicate_packet_send():pid=25565
DEBUG:PGRreplicate_packet_send():from_host=db1.mydomain
DEBUG:PGRreplicate_packet_send():dbName=postgres
DEBUG:PGRreplicate_packet_send():userName=postgres
DEBUG:PGRreplicate_packet_send():recieve sec=1139372688
DEBUG:PGRreplicate_packet_send():recieve usec=699909
DEBUG:PGRreplicate_packet_send():query_size=563
DEBUG:PGRreplicate_packet_send():query=SELECT c.tableoid, c.oid, relname, relacl, relkind, relnamespace, (select usename from pg_user where relowner = usesysid) as usename, relchecks, reltriggers, relhasindex, relhasrules, relhasoids, d.refobjid as owning_tab, d.refobjsubid as owning_col, (SELECT spcname FROM pg_tablespace t WHERE t.oid = c.reltablespace) AS reltablespace from pg_class c left join pg_depend d on (c.relkind = 'S' and d.classid = c.tableoid and d.objid = c.oid and d.objsubid = 0 and d.refclassid = c.tableoid and d.deptype = 'i') where relkind in ('r', 'S', 'v', 'c') order by c.oid
DEBUG:sem_lock[1]
DEBUG:PGRreturn_result():PGRreturn_result[]
DEBUG:PGRreturn_result():wait for answer
DEBUG:send_sync_data():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1139372688,699909,1,1) )
DEBUG:send_sync_data():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1139372688,699909,1,1) )
DEBUG:answer[PGR_QUERY_DONE_NOTICE_CMD]
DEBUG:read_answer():QUERY DONE
DEBUG:PGRreturn_result():status of PGRreturn_result[0]
DEBUG:sem_unlock[1]
DEBUG:replicate_loop():replicate_loop selected
DEBUG:PGRreplicate_packet_send():cmdSts=T
DEBUG:PGRreplicate_packet_send():cmdType=S
DEBUG:PGRreplicate_packet_send():rlog=0
DEBUG:PGRreplicate_packet_send():request_id=21
DEBUG:PGRreplicate_packet_send():replicate_id=0
DEBUG:PGRreplicate_packet_send():port=5432
DEBUG:PGRreplicate_packet_send():pid=25565
DEBUG:PGRreplicate_packet_send():from_host=db1.mydomain
DEBUG:PGRreplicate_packet_send():dbName=postgres
DEBUG:PGRreplicate_packet_send():userName=postgres
DEBUG:PGRreplicate_packet_send():recieve sec=1139372688
DEBUG:PGRreplicate_packet_send():recieve usec=719311
DEBUG:PGRreplicate_packet_send():query_size=43
DEBUG:PGRreplicate_packet_send():query=SELECT inhrelid, inhparent from pg_inherits
DEBUG:sem_lock[1]
DEBUG:PGRreturn_result():PGRreturn_result[]
DEBUG:PGRreturn_result():wait for answer
DEBUG:send_sync_data():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1139372688,719311,1,1) )
DEBUG:send_sync_data():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1139372688,719311,1,1) )
DEBUG:answer[PGR_QUERY_DONE_NOTICE_CMD]
DEBUG:read_answer():QUERY DONE
DEBUG:PGRreturn_result():status of PGRreturn_result[0]
DEBUG:sem_unlock[1]
DEBUG:replicate_loop():replicate_loop selected
DEBUG:PGRreplicate_packet_send():cmdSts=T
DEBUG:PGRreplicate_packet_send():cmdType=S
DEBUG:PGRreplicate_packet_send():rlog=0
DEBUG:PGRreplicate_packet_send():request_id=22
DEBUG:PGRreplicate_packet_send():replicate_id=0
DEBUG:PGRreplicate_packet_send():port=5432
DEBUG:PGRreplicate_packet_send():pid=25565
DEBUG:PGRreplicate_packet_send():from_host=db1.mydomain
DEBUG:PGRreplicate_packet_send():dbName=postgres
DEBUG:PGRreplicate_packet_send():userName=postgres
DEBUG:PGRreplicate_packet_send():recieve sec=1139372688
DEBUG:PGRreplicate_packet_send():recieve usec=724784
DEBUG:PGRreplicate_packet_send():query_size=103
DEBUG:PGRreplicate_packet_send():query=SELECT tableoid, oid, rulename, ev_class as ruletable, ev_type, is_instead FROM pg_rewrite ORDER BY oid
DEBUG:sem_lock[1]
DEBUG:PGRreturn_result():PGRreturn_result[]
DEBUG:PGRreturn_result():wait for answer
DEBUG:send_sync_data():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1139372688,724784,1,1) )
DEBUG:send_sync_data():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1139372688,724784,1,1) )
DEBUG:answer[PGR_QUERY_DONE_NOTICE_CMD]
DEBUG:read_answer():QUERY DONE
DEBUG:PGRreturn_result():status of PGRreturn_result[0]
DEBUG:sem_unlock[1]
DEBUG:replicate_loop():replicate_loop selected
DEBUG:PGRreplicate_packet_send():cmdSts=T
DEBUG:PGRreplicate_packet_send():cmdType=S
DEBUG:PGRreplicate_packet_send():rlog=0
DEBUG:PGRreplicate_packet_send():request_id=23
DEBUG:PGRreplicate_packet_send():replicate_id=0
DEBUG:PGRreplicate_packet_send():port=5432
DEBUG:PGRreplicate_packet_send():pid=25565
DEBUG:PGRreplicate_packet_send():from_host=db1.mydomain
DEBUG:PGRreplicate_packet_send():dbName=postgres
DEBUG:PGRreplicate_packet_send():userName=postgres
DEBUG:PGRreplicate_packet_send():recieve sec=1139372688
DEBUG:PGRreplicate_packet_send():recieve usec=732166
DEBUG:PGRreplicate_packet_send():query_size=93
DEBUG:PGRreplicate_packet_send():query=SELECT tableoid, oid, castsource, casttarget, castfunc, castcontext FROM pg_cast ORDER BY 3,4
DEBUG:sem_lock[1]
DEBUG:PGRreturn_result():PGRreturn_result[]
DEBUG:PGRreturn_result():wait for answer
DEBUG:send_sync_data():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1139372688,732166,1,1) )
DEBUG:send_sync_data():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1139372688,732166,1,1) )
DEBUG:answer[PGR_QUERY_DONE_NOTICE_CMD]
DEBUG:read_answer():QUERY DONE
DEBUG:PGRreturn_result():status of PGRreturn_result[0]
DEBUG:sem_unlock[1]
DEBUG:replicate_loop():replicate_loop selected
DEBUG:PGRreplicate_packet_send():cmdSts=T
DEBUG:PGRreplicate_packet_send():cmdType=S
DEBUG:PGRreplicate_packet_send():rlog=0
DEBUG:PGRreplicate_packet_send():request_id=24
DEBUG:PGRreplicate_packet_send():replicate_id=0
DEBUG:PGRreplicate_packet_send():port=5432
DEBUG:PGRreplicate_packet_send():pid=25565
DEBUG:PGRreplicate_packet_send():from_host=db1.mydomain
DEBUG:PGRreplicate_packet_send():dbName=postgres
DEBUG:PGRreplicate_packet_send():userName=postgres
DEBUG:PGRreplicate_packet_send():recieve sec=1139372688
DEBUG:PGRreplicate_packet_send():recieve usec=745352
DEBUG:PGRreplicate_packet_send():query_size=101
DEBUG:PGRreplicate_packet_send():query=SELECT classid, objid, refclassid, refobjid, deptype FROM pg_depend WHERE deptype != 'p' ORDER BY 1,2
DEBUG:sem_lock[1]
DEBUG:PGRreturn_result():PGRreturn_result[]
DEBUG:PGRreturn_result():wait for answer
DEBUG:send_sync_data():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1139372688,745352,1,1) )
DEBUG:send_sync_data():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1139372688,745352,1,1) )
DEBUG:answer[PGR_QUERY_DONE_NOTICE_CMD]
DEBUG:read_answer():QUERY DONE
DEBUG:PGRreturn_result():status of PGRreturn_result[0]
DEBUG:use[2] host[db1.mydomain] port[5432] life[7201] rec[1]
DEBUG:use[2] host[db2.mydomain] port[5432] life[7201] rec[2]
DEBUG:use[2] host[db3.mydomain] port[5432] life[7201] rec[3]
DEBUG:sem_unlock[1]
DEBUG:replicate_loop():replicate_loop selected
DEBUG:replicate_loop():replicate_loop selected
DEBUG:PGRreplicate_packet_send():cmdSts=T
DEBUG:PGRreplicate_packet_send():cmdType=S
DEBUG:PGRreplicate_packet_send():rlog=0
DEBUG:PGRreplicate_packet_send():request_id=25
DEBUG:PGRreplicate_packet_send():replicate_id=0
DEBUG:PGRreplicate_packet_send():port=5432
DEBUG:PGRreplicate_packet_send():pid=25565
DEBUG:PGRreplicate_packet_send():from_host=db1.mydomain
DEBUG:PGRreplicate_packet_send():dbName=postgres
DEBUG:PGRreplicate_packet_send():userName=postgres
DEBUG:PGRreplicate_packet_send():recieve sec=1139372689
DEBUG:PGRreplicate_packet_send():recieve usec=610443
DEBUG:PGRreplicate_packet_send():query_size=250
DEBUG:PGRreplicate_packet_send():query=SELECT tableoid, oid, (SELECT usename FROM pg_user WHERE usesysid = datdba) as dba, pg_encoding_to_char(encoding) as encoding, (SELECT spcname FROM pg_tablespace t WHERE t.oid = dattablespace) as tablespace FROM pg_database WHERE datname = 'postgres'
DEBUG:sem_lock[1]
DEBUG:PGRreturn_result():PGRreturn_result[]
DEBUG:PGRreturn_result():wait for answer
DEBUG:send_sync_data():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1139372689,610443,1,1) )
DEBUG:send_sync_data():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1139372689,610443,1,1) )
DEBUG:answer[PGR_QUERY_DONE_NOTICE_CMD]
DEBUG:read_answer():QUERY DONE
DEBUG:PGRreturn_result():status of PGRreturn_result[0]
DEBUG:sem_unlock[1]
DEBUG:replicate_loop():replicate_loop selected
DEBUG:PGRreplicate_packet_send():cmdSts=T
DEBUG:PGRreplicate_packet_send():cmdType=S
DEBUG:PGRreplicate_packet_send():rlog=0
DEBUG:PGRreplicate_packet_send():request_id=26
DEBUG:PGRreplicate_packet_send():replicate_id=0
DEBUG:PGRreplicate_packet_send():port=5432
DEBUG:PGRreplicate_packet_send():pid=25565
DEBUG:PGRreplicate_packet_send():from_host=db1.mydomain
DEBUG:PGRreplicate_packet_send():dbName=postgres
DEBUG:PGRreplicate_packet_send():userName=postgres
DEBUG:PGRreplicate_packet_send():recieve sec=1139372689
DEBUG:PGRreplicate_packet_send():recieve usec=617956
DEBUG:PGRreplicate_packet_send():query_size=113
DEBUG:PGRreplicate_packet_send():query=SELECT description, classoid, objoid, objsubid FROM pg_catalog.pg_description ORDER BY classoid, objoid, objsubid
DEBUG:sem_lock[1]
DEBUG:PGRreturn_result():PGRreturn_result[]
DEBUG:PGRreturn_result():wait for answer
DEBUG:send_sync_data():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1139372689,617956,1,1) )
DEBUG:send_sync_data():sync_command(SELECT PGR_SYSTEM_COMMAND_FUNCTION(3,1139372689,617956,1,1) )
DEBUG:answer[PGR_QUERY_DONE_NOTICE_CMD]
DEBUG:read_answer():QUERY DONE
DEBUG:PGRreturn_result():status of PGRreturn_result[0]
DEBUG:sem_unlock[1]
DEBUG:replicate_loop():replicate_loop selected

 ok. stop all child processes
....
 ok. stop all child processes

---
鈴木 文仁 [Suzuki Fumihito]
suzukif ＠ nttdata-hokkaido.co.jp