Tue May 9 21:12:29 PDT 2006
- Previous message: [Slony1-general] Segfault with Slony 1.1.5 and PG 8.1.3 on x86_64
- Next message: [Slony1-general] Initial copy repeating itself
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
all the members in the Slony-I team:
How are you !
use Slony-I sync PostgreSQL7.4 have a long time.
but along with Application biger and biger.
need synchronous sequence and table more and more.
number of table : 113
number of sequence : 37
Start slonyI's command :
slon -s 2000 tc1 "dbname=tc user=tc host=10.10.10.133 port=5432" >> /var/log/slony/tc/slon.log &
PostgreSQL verion:
version
----------------------------------------------------------------
PostgreSQL 7.4 on sparc-sun-solaris2.8, compiled by GCC 2.95.3
(1 row)
I find one question:
1)data sync not in time and have miss data instance
(at 4:32:2am compare the data between Master and Slave , find have a lot of data at a field of table is different
these field sometimes is modify high frequency, Slave not sync these data, result in data different )
About this question, maybe
1> table and sequence is too much in set ?
2> sync interval is too long (once a 2000 millisecond) ?
Question1 :How to separate a large set to two or three smaller set?
Question2 :if I shorten sync interval , what question should pay attention to it? maybe result in lock?
Question3: Do slonyI running could effect performance of access database ?
follow is our set :
CLUSTERNAME=tc1
MASTERDBNAME=tc
MASTERPORT=5432
SLAVEDBNAME1=tc
SLAVEPORT1=5432
MASTERHOST=10.10.10.133
SLAVEHOST1=10.10.10.111
REPLICATIONUSER=tc
PGBENCHUSER1=tc
export CLUSTERNAME MASTERDBNAME MASTERPORT SLAVEDBNAME1 SLAVEPORT1 MASTERHOST SLAVEHOST1 REPLICATIONUSER PGBENCHUSER1
slonik <<_EOF_
#--
# define the namespace the replication system uses in our example it is
# slony_example
#--
cluster name = $CLUSTERNAME;
#--
# admin conninfo's are used by slonik to connect to the nodes one for each
# node on each side of the cluster, the syntax is that of PQconnectdb in
# the C-API
# --
node 1 admin conninfo = 'dbname=$MASTERDBNAME host=$MASTERHOST user=$REPLICATIONUSER';
node 2 admin conninfo = 'dbname=$SLAVEDBNAME1 host=$SLAVEHOST1 user=$PGBENCHUSER1';
#--
# init the first node. Its id MUST be 1. This creates the schema
# _$CLUSTERNAME containing all replication system specific database
# objects.
#--
init cluster ( id=1, comment = '10.10.10.133 tc Master Node');
#1
table add key (node id = 1, fully qualified name = 'public.mail_user');
#2
table add key (node id = 1, fully qualified name = 'public.release_history');
#3
table add key (node id = 1, fully qualified name = 'public.t_ar_invoice');
#4
table add key (node id = 1, fully qualified name = 'public.t_ar_line');
#5
table add key (node id = 1, fully qualified name = 'public.t_coach_fee_setup');
#6
table add key (node id = 1, fully qualified name = 'public.t_course_setup');
#7
table add key (node id = 1, fully qualified name = 'public.t_employees');
#8
table add key (node id = 1, fully qualified name = 'public.t_player_score');
#9
table add key (node id = 1, fully qualified name = 'public.t_sms_record');
#10
table add key (node id = 1, fully qualified name = 'public.user_entry');
#--
# Slony-I organizes tables into sets. The smallest unit a node can
# subscribe is a set. The following commands create one set containing
# all 4 pgbench tables. The master or origin of the set is node 1.
#--
create set (id=1, origin=1, comment='All tc tables 2006Ä?4ÔÂ30ÈÕ 12:59:27');
SET ADD SEQUENCE ( SET ID = 1, ORIGIN = 1, ID = 1 , FULLY QUALIFIED NAME = 'public.seq_account_basic_info_account_id', COMMENT = 'seq_account_basic_info_account_id' );
SET ADD SEQUENCE ( SET ID = 1, ORIGIN = 1, ID = 2 , FULLY QUALIFIED NAME = 'public.seq_ar_id', COMMENT = 'seq_ar_id' );
SET ADD SEQUENCE ( SET ID = 1, ORIGIN = 1, ID = 3 , FULLY QUALIFIED NAME = 'public.seq_batting_line_line_id', COMMENT = 'seq_batting_line_line_id' );
SET ADD SEQUENCE ( SET ID = 1, ORIGIN = 1, ID = 4 , FULLY QUALIFIED NAME = 'public.seq_business_card_open_line_index_id', COMMENT = 'seq_business_card_open_line_index_id' );
SET ADD SEQUENCE ( SET ID = 1, ORIGIN = 1, ID = 5 , FULLY QUALIFIED NAME = 'public.seq_club_club_id', COMMENT = 'seq_club_club_id' );
SET ADD SEQUENCE ( SET ID = 1, ORIGIN = 1, ID = 6 , FULLY QUALIFIED NAME = 'public.seq_company_company_id', COMMENT = 'seq_company_company_id' );
SET ADD SEQUENCE ( SET ID = 1, ORIGIN = 1, ID = 7 , FULLY QUALIFIED NAME = 'public.seq_conf_product_id', COMMENT = 'seq_conf_product_id' );
SET ADD SEQUENCE ( SET ID = 1, ORIGIN = 1, ID = 8 , FULLY QUALIFIED NAME = 'public.seq_conf_product_line_id', COMMENT = 'seq_conf_product_line_id' );
SET ADD SEQUENCE ( SET ID = 1, ORIGIN = 1, ID = 9 , FULLY QUALIFIED NAME = 'public.seq_court_account_detail_index_id', COMMENT = 'seq_court_account_detail_index_id' );
SET ADD SEQUENCE ( SET ID = 1, ORIGIN = 1, ID = 10 , FULLY QUALIFIED NAME = 'public.seq_court_court_id', COMMENT = 'seq_court_court_id' );
SET ADD SEQUENCE ( SET ID = 1, ORIGIN = 1, ID = 11 , FULLY QUALIFIED NAME = 'public.seq_court_group_info_field_id', COMMENT = 'seq_court_group_info_field_id' );
SET ADD SEQUENCE ( SET ID = 1, ORIGIN = 1, ID = 12 , FULLY QUALIFIED NAME = 'public.seq_court_setup_index_id', COMMENT = 'seq_court_setup_index_id' );
SET ADD SEQUENCE ( SET ID = 1, ORIGIN = 1, ID = 13 , FULLY QUALIFIED NAME = 'public.seq_dn_line_id', COMMENT = 'seq_dn_line_id' );
SET ADD SEQUENCE ( SET ID = 1, ORIGIN = 1, ID = 14 , FULLY QUALIFIED NAME = 'public.seq_employees_e_id', COMMENT = 'seq_employees_e_id' );
SET ADD SEQUENCE ( SET ID = 1, ORIGIN = 1, ID = 15 , FULLY QUALIFIED NAME = 'public.seq_member_account_detail_index_id', COMMENT = 'seq_member_account_detail_index_id' );
SET ADD SEQUENCE ( SET ID = 1, ORIGIN = 1, ID = 16 , FULLY QUALIFIED NAME = 'public.seq_member_cards_index', COMMENT = 'seq_member_cards_index' );
SET ADD SEQUENCE ( SET ID = 1, ORIGIN = 1, ID = 17 , FULLY QUALIFIED NAME = 'public.seq_member_cards_serial_id', COMMENT = 'seq_member_cards_serial_id' );
SET ADD SEQUENCE ( SET ID = 1, ORIGIN = 1, ID = 18 , FULLY QUALIFIED NAME = 'public.seq_members_member_num', COMMENT = 'seq_members_member_num' );
SET ADD SEQUENCE ( SET ID = 1, ORIGIN = 1, ID = 19 , FULLY QUALIFIED NAME = 'public.seq_my_course_id', COMMENT = 'seq_my_course_id' );
SET ADD SEQUENCE ( SET ID = 1, ORIGIN = 1, ID = 20 , FULLY QUALIFIED NAME = 'public.seq_my_friend_friend_id', COMMENT = 'seq_my_friend_friend_id' );
SET ADD SEQUENCE ( SET ID = 1, ORIGIN = 1, ID = 21 , FULLY QUALIFIED NAME = 'public.seq_product_id', COMMENT = 'seq_product_id' );
SET ADD SEQUENCE ( SET ID = 1, ORIGIN = 1, ID = 22 , FULLY QUALIFIED NAME = 'public.seq_product_stock_index_id', COMMENT = 'seq_product_stock_index_id' );
SET ADD SEQUENCE ( SET ID = 1, ORIGIN = 1, ID = 23 , FULLY QUALIFIED NAME = 'public.seq_rn_line_id', COMMENT = 'seq_rn_line_id' );
SET ADD SEQUENCE ( SET ID = 1, ORIGIN = 1, ID = 24 , FULLY QUALIFIED NAME = 'public.seq_service_and_conf_id', COMMENT = 'seq_service_and_conf_id' );
SET ADD SEQUENCE ( SET ID = 1, ORIGIN = 1, ID = 25 , FULLY QUALIFIED NAME = 'public.seq_t_bank_order_line_preorder_num', COMMENT = 'seq_t_bank_order_line_preorder_num' );
SET ADD SEQUENCE ( SET ID = 1, ORIGIN = 1, ID = 26 , FULLY QUALIFIED NAME = 'public.seq_t_bank_order_members_member_id', COMMENT = 'seq_t_bank_order_members_member_id' );
SET ADD SEQUENCE ( SET ID = 1, ORIGIN = 1, ID = 27 , FULLY QUALIFIED NAME = 'public.seq_t_cards_account_detail_index_id', COMMENT = 'seq_t_cards_account_detail_index_id' );
SET ADD SEQUENCE ( SET ID = 1, ORIGIN = 1, ID = 28 , FULLY QUALIFIED NAME = 'public.seq_t_emp_of_dept_index_id', COMMENT = 'seq_t_emp_of_dept_index_id' );
SET ADD SEQUENCE ( SET ID = 1, ORIGIN = 1, ID = 29 , FULLY QUALIFIED NAME = 'public.seq_t_exchange_rate_index_id', COMMENT = 'seq_t_exchange_rate_index_id' );
SET ADD SEQUENCE ( SET ID = 1, ORIGIN = 1, ID = 30 , FULLY QUALIFIED NAME = 'public.seq_t_gp_bank_account_index_id', COMMENT = 'seq_t_gp_bank_account_index_id' );
SET ADD SEQUENCE ( SET ID = 1, ORIGIN = 1, ID = 31 , FULLY QUALIFIED NAME = 'public.seq_t_roles_role_id', COMMENT = 'seq_t_roles_role_id' );
SET ADD SEQUENCE ( SET ID = 1, ORIGIN = 1, ID = 32 , FULLY QUALIFIED NAME = 'public.seq_t_time_sharing_booking_line_id', COMMENT = 'seq_t_time_sharing_booking_line_id' );
SET ADD SEQUENCE ( SET ID = 1, ORIGIN = 1, ID = 33 , FULLY QUALIFIED NAME = 'public.seq_t_time_sharing_line_index', COMMENT = 'seq_t_time_sharing_line_index' );
SET ADD SEQUENCE ( SET ID = 1, ORIGIN = 1, ID = 34 , FULLY QUALIFIED NAME = 'public.seq_t_web_pay_line_id', COMMENT = 'seq_t_web_pay_line_id' );
SET ADD SEQUENCE ( SET ID = 1, ORIGIN = 1, ID = 35 , FULLY QUALIFIED NAME = 'public.seq_t_web_pay_preorder_digital_num', COMMENT = 'seq_t_web_pay_preorder_digital_num' );
SET ADD SEQUENCE ( SET ID = 1, ORIGIN = 1, ID = 36 , FULLY QUALIFIED NAME = 'public.seq_tmp_digital_num', COMMENT = 'seq_tmp_digital_num' );
SET ADD SEQUENCE ( SET ID = 1, ORIGIN = 1, ID = 37 , FULLY QUALIFIED NAME = 'public.seq_user_index', COMMENT = 'seq_user_index' );
#1-10
set add table (set id=1, origin=1, id=1, fully qualified name = 'public.express_info_setup', comment='Table: express_info_setup');
set add table (set id=1, origin=1, id=2, fully qualified name = 'public.mail_user', comment='Table: mail_user', key = serial);
set add table (set id=1, origin=1, id=3, fully qualified name = 'public.release_history', comment='Table: release_history', key = serial);
set add table (set id=1, origin=1, id=4, fully qualified name = 'public.t_account_basic_info', comment='Table: t_account_basic_info');
set add table (set id=1, origin=1, id=5, fully qualified name = 'public.t_add_preorder', comment='Table: t_add_preorder');
set add table (set id=1, origin=1, id=6, fully qualified name = 'public.t_add_preorder_line', comment='Table: t_add_preorder_line');
set add table (set id=1, origin=1, id=7, fully qualified name = 'public.t_ap_mounth', comment='Table: t_ap_mounth');
set add table (set id=1, origin=1, id=8, fully qualified name = 'public.t_ar', comment='Table: t_ar');
set add table (set id=1, origin=1, id=9, fully qualified name = 'public.t_ar_invoice', comment='Table: t_ar_invoice', key = serial);
set add table (set id=1, origin=1, id=10, fully qualified name = 'public.t_ar_line', comment='Table: t_ar_line', key = serial);
#11-20
set add table (set id=1, origin=1, id=11, fully qualified name = 'public.t_bank_members_friends', comment='Table: t_bank_members_friends');
set add table (set id=1, origin=1, id=12, fully qualified name = 'public.t_bank_order', comment='Table: t_bank_order');
set add table (set id=1, origin=1, id=13, fully qualified name = 'public.t_bank_order_cards', comment='Table: t_bank_order_cards');
set add table (set id=1, origin=1, id=14, fully qualified name = 'public.t_bank_order_cards_account', comment='Table: t_bank_order_cards_account');
set add table (set id=1, origin=1, id=15, fully qualified name = 'public.t_bank_order_line', comment='Table: t_bank_order_line');
set add table (set id=1, origin=1, id=16, fully qualified name = 'public.t_bank_order_line_detail', comment='Table: t_bank_order_line_detail');
set add table (set id=1, origin=1, id=17, fully qualified name = 'public.t_bank_order_members', comment='Table: t_bank_order_members');
set add table (set id=1, origin=1, id=18, fully qualified name = 'public.t_bank_order_security_user', comment='Table: t_bank_order_security_user');
set add table (set id=1, origin=1, id=19, fully qualified name = 'public.t_bank_order_user_info', comment='Table: t_bank_order_user_info');
set add table (set id=1, origin=1, id=20, fully qualified name = 'public.t_batting_line', comment='Table: t_batting_line');
#21-30
set add table (set id=1, origin=1, id=21, fully qualified name = 'public.t_biz_card_onnet_open_basic', comment='Table: t_biz_card_onnet_open_basic');
set add table (set id=1, origin=1, id=22, fully qualified name = 'public.t_biz_card_onnet_open_line', comment='Table: t_biz_card_onnet_open_line');
set add table (set id=1, origin=1, id=23, fully qualified name = 'public.t_biz_card_onnet_used_detail', comment='Table: t_biz_card_onnet_used_detail');
set add table (set id=1, origin=1, id=24, fully qualified name = 'public.t_branch_company', comment='Table: t_branch_company');
set add table (set id=1, origin=1, id=25, fully qualified name = 'public.t_business_card_open_basic', comment='Table: t_business_card_open_basic');
set add table (set id=1, origin=1, id=26, fully qualified name = 'public.t_business_card_open_line', comment='Table: t_business_card_open_line');
set add table (set id=1, origin=1, id=27, fully qualified name = 'public.t_business_card_used_detail', comment='Table: t_business_card_used_detail');
set add table (set id=1, origin=1, id=28, fully qualified name = 'public.t_card_time_rules_init', comment='Table: t_card_time_rules_init');
set add table (set id=1, origin=1, id=29, fully qualified name = 'public.t_cards_account_detail', comment='Table: t_cards_account_detail');
##set add table (set id=1, origin=1, id=30, fully qualified name = 'public.t_club', comment='Table: t_club');
#old is 111
set add table (set id=1, origin=1, id=30, fully qualified name = 'public.t_web_pay_security_user', comment='Table: t_web_pay_security_user');
#31-40
set add table (set id=1, origin=1, id=31, fully qualified name = 'public.t_coach', comment='Table: t_coach');
set add table (set id=1, origin=1, id=32, fully qualified name = 'public.t_coach_fee_setup', comment='Table: t_coach_fee_setup', key = serial);
set add table (set id=1, origin=1, id=33, fully qualified name = 'public.t_coach_of_court', comment='Table: t_coach_of_court');
set add table (set id=1, origin=1, id=34, fully qualified name = 'public.t_company', comment='Table: t_company');
set add table (set id=1, origin=1, id=35, fully qualified name = 'public.t_conf_product', comment='Table: t_conf_product');
set add table (set id=1, origin=1, id=36, fully qualified name = 'public.t_conf_product_line', comment='Table: t_conf_product_line');
set add table (set id=1, origin=1, id=37, fully qualified name = 'public.t_course_setup', comment='Table: t_course_setup', key = serial);
## set add table (set id=1, origin=1, id=38, fully qualified name = 'public.t_court', comment='Table: t_court');
#old is 112
set add table (set id=1, origin=1, id=38, fully qualified name = 'public.t_web_pay_user_info', comment='Table: t_web_pay_user_info');
set add table (set id=1, origin=1, id=39, fully qualified name = 'public.t_court_account_detail', comment='Table: t_court_account_detail');
set add table (set id=1, origin=1, id=40, fully qualified name = 'public.t_court_balance_deatil', comment='Table: t_court_balance_deatil');
#41-50
set add table (set id=1, origin=1, id=41, fully qualified name = 'public.t_court_group_info', comment='Table: t_court_group_info');
set add table (set id=1, origin=1, id=42, fully qualified name = 'public.t_court_other_info', comment='Table: t_court_other_info');
set add table (set id=1, origin=1, id=43, fully qualified name = 'public.t_court_setup', comment='Table: t_court_setup');
set add table (set id=1, origin=1, id=44, fully qualified name = 'public.t_currency', comment='Table: t_currency');
set add table (set id=1, origin=1, id=45, fully qualified name = 'public.t_department', comment='Table: t_department');
set add table (set id=1, origin=1, id=46, fully qualified name = 'public.t_direct_members', comment='Table: t_direct_members');
set add table (set id=1, origin=1, id=47, fully qualified name = 'public.t_direct_pass_card_open_basic', comment='Table: t_direct_pass_card_open_basic');
set add table (set id=1, origin=1, id=48, fully qualified name = 'public.t_direct_pass_card_open_line', comment='Table: t_direct_pass_card_open_line');
set add table (set id=1, origin=1, id=49, fully qualified name = 'public.t_dn', comment='Table: t_dn');
set add table (set id=1, origin=1, id=50, fully qualified name = 'public.t_dn_line', comment='Table: t_dn_line');
#51-60
set add table (set id=1, origin=1, id=51, fully qualified name = 'public.t_emp_of_dept', comment='Table: t_emp_of_dept');
set add table (set id=1, origin=1, id=52, fully qualified name = 'public.t_employees', comment='Table: t_employees', key = serial);
set add table (set id=1, origin=1, id=53, fully qualified name = 'public.t_ems_cards_info', comment='Table: t_ems_cards_info');
set add table (set id=1, origin=1, id=54, fully qualified name = 'public.t_exchange_rate', comment='Table: t_exchange_rate');
set add table (set id=1, origin=1, id=55, fully qualified name = 'public.t_gp_bank_account_detail', comment='Table: t_gp_bank_account_detail');
set add table (set id=1, origin=1, id=56, fully qualified name = 'public.t_hotel', comment='Table: t_hotel');
set add table (set id=1, origin=1, id=57, fully qualified name = 'public.t_match_field_info', comment='Table: t_match_field_info');
set add table (set id=1, origin=1, id=58, fully qualified name = 'public.t_match_score', comment='Table: t_match_score');
set add table (set id=1, origin=1, id=59, fully qualified name = 'public.t_member_account_detail', comment='Table: t_member_account_detail');
set add table (set id=1, origin=1, id=60, fully qualified name = 'public.t_member_cards', comment='Table: t_member_cards');
#61-70
set add table (set id=1, origin=1, id=61, fully qualified name = 'public.t_members', comment='Table: t_members');
set add table (set id=1, origin=1, id=62, fully qualified name = 'public.t_module_parameter', comment='Table: t_module_parameter');
set add table (set id=1, origin=1, id=63, fully qualified name = 'public.t_modules', comment='Table: t_modules');
set add table (set id=1, origin=1, id=64, fully qualified name = 'public.t_my_course', comment='Table: t_my_course');
set add table (set id=1, origin=1, id=65, fully qualified name = 'public.t_my_friend', comment='Table: t_my_friend');
set add table (set id=1, origin=1, id=66, fully qualified name = 'public.t_num_center', comment='Table: t_num_center');
set add table (set id=1, origin=1, id=67, fully qualified name = 'public.t_package_child', comment='Table: t_package_child');
set add table (set id=1, origin=1, id=68, fully qualified name = 'public.t_package_conf', comment='Table: t_package_conf');
set add table (set id=1, origin=1, id=69, fully qualified name = 'public.t_pass_card_open_basic', comment='Table: t_pass_card_open_basic');
set add table (set id=1, origin=1, id=70, fully qualified name = 'public.t_pass_card_open_line', comment='Table: t_pass_card_open_line');
#71-80
set add table (set id=1, origin=1, id=71, fully qualified name = 'public.t_pass_card_rules', comment='Table: t_pass_card_rules');
set add table (set id=1, origin=1, id=72, fully qualified name = 'public.t_pass_card_setup', comment='Table: t_pass_card_setup');
set add table (set id=1, origin=1, id=73, fully qualified name = 'public.t_passcard_of_agency', comment='Table: t_passcard_of_agency');
set add table (set id=1, origin=1, id=74, fully qualified name = 'public.t_passcard_of_hotel', comment='Table: t_passcard_of_hotel');
set add table (set id=1, origin=1, id=75, fully qualified name = 'public.t_pay_center', comment='Table: t_pay_center');
set add table (set id=1, origin=1, id=76, fully qualified name = 'public.t_player_score', comment='Table: t_player_score', key = serial);
set add table (set id=1, origin=1, id=77, fully qualified name = 'public.t_preorder', comment='Table: t_preorder');
set add table (set id=1, origin=1, id=78, fully qualified name = 'public.t_preorder_line_his', comment='Table: t_preorder_line_his');
set add table (set id=1, origin=1, id=79, fully qualified name = 'public.t_presell_cards', comment='Table: t_presell_cards');
set add table (set id=1, origin=1, id=80, fully qualified name = 'public.t_privilege', comment='Table: t_privilege');
#81-90
set add table (set id=1, origin=1, id=81, fully qualified name = 'public.t_product', comment='Table: t_product');
set add table (set id=1, origin=1, id=82, fully qualified name = 'public.t_product_stock', comment='Table: t_product_stock');
set add table (set id=1, origin=1, id=83, fully qualified name = 'public.t_product_type', comment='Table: t_product_type');
set add table (set id=1, origin=1, id=84, fully qualified name = 'public.t_replace_cards_his', comment='Table: t_replace_cards_his');
set add table (set id=1, origin=1, id=85, fully qualified name = 'public.t_rn', comment='Table: t_rn');
set add table (set id=1, origin=1, id=86, fully qualified name = 'public.t_rn_line', comment='Table: t_rn_line');
set add table (set id=1, origin=1, id=87, fully qualified name = 'public.t_roles', comment='Table: t_roles');
set add table (set id=1, origin=1, id=88, fully qualified name = 'public.t_sales_detail_report', comment='Table: t_sales_detail_report');
set add table (set id=1, origin=1, id=89, fully qualified name = 'public.t_security_user', comment='Table: t_security_user');
set add table (set id=1, origin=1, id=90, fully qualified name = 'public.t_service_and_conf', comment='Table: t_service_and_conf');
#91-100
set add table (set id=1, origin=1, id=91, fully qualified name = 'public.t_sms_manger', comment='Table: t_sms_manger');
set add table (set id=1, origin=1, id=92, fully qualified name = 'public.t_sms_not_send', comment='Table: t_sms_not_send');
set add table (set id=1, origin=1, id=93, fully qualified name = 'public.t_sms_record', comment='Table: t_sms_record', key = serial);
set add table (set id=1, origin=1, id=94, fully qualified name = 'public.t_temp_member_cards', comment='Table: t_temp_member_cards');
set add table (set id=1, origin=1, id=95, fully qualified name = 'public.t_time_sharing_booking', comment='Table: t_time_sharing_booking');
set add table (set id=1, origin=1, id=96, fully qualified name = 'public.t_time_sharing_booking_line', comment='Table: t_time_sharing_booking_line');
set add table (set id=1, origin=1, id=97, fully qualified name = 'public.t_time_sharing_pay', comment='Table: t_time_sharing_pay');
set add table (set id=1, origin=1, id=98, fully qualified name = 'public.t_time_sharing_pay_line', comment='Table: t_time_sharing_pay_line');
set add table (set id=1, origin=1, id=99, fully qualified name = 'public.t_times_rules_setup', comment='Table: t_times_rules_setup');
set add table (set id=1, origin=1, id=100, fully qualified name = 'public.t_travel_agency', comment='Table: t_travel_agency');
#101-110
set add table (set id=1, origin=1, id=101, fully qualified name = 'public.t_travel_agency_approve_info', comment='Table: t_travel_agency_approve_info');
set add table (set id=1, origin=1, id=102, fully qualified name = 'public.t_travel_agency_approve_line', comment='Table: t_travel_agency_approve_line');
set add table (set id=1, origin=1, id=103, fully qualified name = 'public.t_travel_agency_employees', comment='Table: t_travel_agency_employees');
set add table (set id=1, origin=1, id=104, fully qualified name = 'public.t_user_info', comment='Table: t_user_info');
set add table (set id=1, origin=1, id=105, fully qualified name = 'public.t_visited_qty_report', comment='Table: t_visited_qty_report');
set add table (set id=1, origin=1, id=106, fully qualified name = 'public.t_visited_times_report', comment='Table: t_visited_times_report');
set add table (set id=1, origin=1, id=107, fully qualified name = 'public.t_warehouse', comment='Table: t_warehouse');
set add table (set id=1, origin=1, id=108, fully qualified name = 'public.t_web_pay_court_fee', comment='Table: t_web_pay_court_fee');
set add table (set id=1, origin=1, id=109, fully qualified name = 'public.t_web_pay_line', comment='Table: t_web_pay_line');
set add table (set id=1, origin=1, id=110, fully qualified name = 'public.t_web_pay_preorder', comment='Table: t_web_pay_preorder');
#111-113
#set add table (set id=1, origin=1, id=111, fully qualified name = 'public.t_web_pay_security_user', comment='Table: t_web_pay_security_user');
#set add table (set id=1, origin=1, id=112, fully qualified name = 'public.t_web_pay_user_info', comment='Table: t_web_pay_user_info');
#set add table (set id=1, origin=1, id=113, fully qualified name = 'public.user_entry', comment='Table: user_entry', key = serial);
set add table (set id=1, origin=1, id=111, fully qualified name = 'public.user_entry', comment='Table: user_entry', key = serial);
set add table (set id=1, origin=1, id=112, fully qualified name = 'public.t_court', comment='Table: t_court');
set add table (set id=1, origin=1, id=113, fully qualified name = 'public.t_club', comment='Table: t_club');
#--
# Create the second node (the slave) tell the 2 nodes how to connect to
# each other and how they should listen for events.
#--
store node (id=2, comment = '10.10.10.111 tc Slave node');
store path (server = 1, client = 2, conninfo='dbname=$MASTERDBNAME host=$MASTERHOST user=$REPLICATIONUSER');
store path (server = 2, client = 1, conninfo='dbname=$SLAVEDBNAME1 host=$SLAVEHOST1 user=$PGBENCHUSER1');
store listen (origin=1, provider = 1, receiver =2);
store listen (origin=2, provider = 2, receiver =1);
_EOF_
------------------------------------------------------------------------------------------
slonik <<_EOF_
# ----
# This defines which namespace the replication system uses
# ----
cluster name = $CLUSTERNAME;
# ----
# Admin conninfo's are used by the slonik program to connect
# to the node databases. So these are the PQconnectdb arguments
# that connect from the administrators workstation (where
# slonik is executed).
# ----
node 1 admin conninfo = 'dbname=$MASTERDBNAME host=$MASTERHOST user=$REPLICATIONUSER';
node 2 admin conninfo = 'dbname=$SLAVEDBNAME1 host=$SLAVEHOST1 user=$PGBENCHUSER1';
# ----
# Node 2 subscribes set 1
# ----
subscribe set ( id = 1, provider = 1, receiver = 2, forward = no);
_EOF_
wait for answer in urgency , Thanks for any help . look forward to email.Thank you very much .
good regard everyboady!
---------------------------------
????????-3.5G???20M???
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://gborg.postgresql.org/pipermail/slony1-general/attachments/20060510/faee7435/attachment-0001.html
- Previous message: [Slony1-general] Segfault with Slony 1.1.5 and PG 8.1.3 on x86_64
- Next message: [Slony1-general] Initial copy repeating itself
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list