[Pgpool-general] cont. pgpool with enterprisedb + slony-I

Wed Mar 29 23:22:55 GMT 2006

Hi all,
I cannot post reply to my previous thread (do not know how to)
I am running pgpool-3.0.0-1.i386.rpm installed on FedoraCore3 with
EnterpriseDB_8.1.3.12 + bundled Slony-I

Question: Am I suppose to run pgpool where enterprisedb running. In this case
yes, I am running pgpool where I am running enterprisedb server (on master).

(master 203 : running enterprisedb + slony-I + pgpool)
(slave 204  : running enterprisedb + slony-I)

(Actually I have tried also running pgpool on different machine say 205)

I was wondering if I could run pgpool on machine say 205 as a loadbalancer if I
could get to work my current problem?

Here is my logfile output with -d option:
***********************************************
2006-03-30 20:29:37 DEBUG: pid 10623: key: listen_addresses
2006-03-30 20:29:37 DEBUG: pid 10623: value: '*' kind: 4
2006-03-30 20:29:37 DEBUG: pid 10623: key: port
2006-03-30 20:29:37 DEBUG: pid 10623: value: 9999 kind: 2
2006-03-30 20:29:37 DEBUG: pid 10623: key: socket_dir
2006-03-30 20:29:37 DEBUG: pid 10623: value: '/tmp' kind: 4
2006-03-30 20:29:37 DEBUG: pid 10623: key: backend_host_name
2006-03-30 20:29:37 DEBUG: pid 10623: value: '192.168.5.203' kind: 4
2006-03-30 20:29:37 DEBUG: pid 10623: :192.168.5.203:
2006-03-30 20:29:37 DEBUG: pid 10623: key: backend_port
2006-03-30 20:29:37 DEBUG: pid 10623: value: 5444 kind: 2
2006-03-30 20:29:37 DEBUG: pid 10623: key: backend_socket_dir
2006-03-30 20:29:37 DEBUG: pid 10623: value: '/tmp' kind: 4
2006-03-30 20:29:37 DEBUG: pid 10623: key: secondary_backend_host_name
2006-03-30 20:29:37 DEBUG: pid 10623: value: '192.168.5.204' kind: 4
2006-03-30 20:29:37 DEBUG: pid 10623: :192.168.5.204:
2006-03-30 20:29:37 DEBUG: pid 10623: key: secondary_backend_port
2006-03-30 20:29:37 DEBUG: pid 10623: value: 5444 kind: 2
2006-03-30 20:29:37 DEBUG: pid 10623: key: num_init_children
2006-03-30 20:29:37 DEBUG: pid 10623: value: 32 kind: 2
2006-03-30 20:29:37 DEBUG: pid 10623: key: max_pool
2006-03-30 20:29:37 DEBUG: pid 10623: value: 4 kind: 2
2006-03-30 20:29:37 DEBUG: pid 10623: key: child_life_time
2006-03-30 20:29:37 DEBUG: pid 10623: value: 300 kind: 2
2006-03-30 20:29:37 DEBUG: pid 10623: key: connection_life_time
2006-03-30 20:29:37 DEBUG: pid 10623: value: 0 kind: 2
2006-03-30 20:29:37 DEBUG: pid 10623: key: child_max_connections
2006-03-30 20:29:37 DEBUG: pid 10623: value: 0 kind: 2
2006-03-30 20:29:37 DEBUG: pid 10623: key: logdir
2006-03-30 20:29:37 DEBUG: pid 10623: value: '/tmp' kind: 4
2006-03-30 20:29:37 DEBUG: pid 10623: key: replication_mode
2006-03-30 20:29:37 DEBUG: pid 10623: value: false kind: 1
2006-03-30 20:29:37 DEBUG: pid 10623: key: replication_strict
2006-03-30 20:29:37 DEBUG: pid 10623: value: true kind: 1
2006-03-30 20:29:37 DEBUG: pid 10623: key: replication_timeout
2006-03-30 20:29:37 DEBUG: pid 10623: value: 5000 kind: 2
2006-03-30 20:29:37 DEBUG: pid 10623: key: load_balance_mode
2006-03-30 20:29:37 DEBUG: pid 10623: value: true kind: 1
2006-03-30 20:29:37 DEBUG: pid 10623: key: weight_master
2006-03-30 20:29:37 DEBUG: pid 10623: value: 0.5 kind: 3
2006-03-30 20:29:37 DEBUG: pid 10623: weight_master: 0.500000
2006-03-30 20:29:37 DEBUG: pid 10623: key: weight_secondary
2006-03-30 20:29:37 DEBUG: pid 10623: value: 0.5 kind: 3
2006-03-30 20:29:37 DEBUG: pid 10623: weight_secondary: 0.500000
2006-03-30 20:29:37 DEBUG: pid 10623: key: replication_stop_on_mismatch
2006-03-30 20:29:37 DEBUG: pid 10623: value: false kind: 1
2006-03-30 20:29:37 DEBUG: pid 10623: replication_stop_on_mismatch: 0
2006-03-30 20:29:37 DEBUG: pid 10623: key: reset_query_list
2006-03-30 20:29:37 DEBUG: pid 10623: value: 'ABORT; RESET ALL; SET SESSION
AUTHORIZATION DEFAULT' kind: 4
2006-03-30 20:29:37 DEBUG: pid 10623: extract_string_tokens: token: ABORT
2006-03-30 20:29:37 DEBUG: pid 10623: extract_string_tokens: token:  RESET ALL
2006-03-30 20:29:37 DEBUG: pid 10623: extract_string_tokens: token:  SET SESSION
AUTHORIZATION DEFAULT
2006-03-30 20:29:37 DEBUG: pid 10623: key: print_timestamp
2006-03-30 20:29:37 DEBUG: pid 10623: value: true kind: 1
2006-03-30 20:29:37 DEBUG: pid 10623: key: master_slave_mode
2006-03-30 20:29:37 DEBUG: pid 10623: value: true kind: 1
2006-03-30 20:29:37 DEBUG: pid 10623: key: connection_cache
2006-03-30 20:29:38 DEBUG: pid 10623: value: true kind: 1
2006-03-30 20:29:38 DEBUG: pid 10623: key: health_check_timeout
2006-03-30 20:29:38 DEBUG: pid 10623: value: 20 kind: 2
2006-03-30 20:29:38 DEBUG: pid 10623: key: health_check_period
2006-03-30 20:29:38 DEBUG: pid 10623: value: 60 kind: 2
2006-03-30 20:29:38 DEBUG: pid 10623: key: health_check_user
2006-03-30 20:29:38 DEBUG: pid 10623: value: 'enterprisedb' kind: 4
2006-03-30 20:29:38 DEBUG: pid 10623: key: insert_lock
2006-03-30 20:29:38 DEBUG: pid 10623: value: false kind: 1
2006-03-30 20:29:38 DEBUG: pid 10623: key: ignore_leading_white_space
2006-03-30 20:29:38 DEBUG: pid 10623: value: true kind: 1
2006-03-30 20:29:38 DEBUG: pid 10623: weight: 1073741823
2006-03-30 20:29:38 DEBUG: pid 10624: I am 10624
2006-03-30 20:29:38 DEBUG: pid 10626: I am 10626
2006-03-30 20:29:38 DEBUG: pid 10627: I am 10627
2006-03-30 20:29:38 DEBUG: pid 10628: I am 10628
2006-03-30 20:29:38 DEBUG: pid 10625: I am 10625
2006-03-30 20:29:38 DEBUG: pid 10629: I am 10629
2006-03-30 20:29:38 DEBUG: pid 10630: I am 10630
2006-03-30 20:29:38 DEBUG: pid 10631: I am 10631
2006-03-30 20:29:38 DEBUG: pid 10632: I am 10632
2006-03-30 20:29:38 DEBUG: pid 10634: I am 10634
2006-03-30 20:29:38 DEBUG: pid 10635: I am 10635
2006-03-30 20:29:38 DEBUG: pid 10636: I am 10636
2006-03-30 20:29:38 DEBUG: pid 10633: I am 10633
2006-03-30 20:29:38 DEBUG: pid 10637: I am 10637
2006-03-30 20:29:38 DEBUG: pid 10638: I am 10638
2006-03-30 20:29:38 DEBUG: pid 10639: I am 10639
2006-03-30 20:29:39 DEBUG: pid 10640: I am 10640
2006-03-30 20:29:39 DEBUG: pid 10641: I am 10641
2006-03-30 20:29:39 DEBUG: pid 10642: I am 10642
2006-03-30 20:29:39 DEBUG: pid 10643: I am 10643
2006-03-30 20:29:39 DEBUG: pid 10644: I am 10644
2006-03-30 20:29:39 DEBUG: pid 10645: I am 10645
2006-03-30 20:29:39 DEBUG: pid 10646: I am 10646
2006-03-30 20:29:39 DEBUG: pid 10647: I am 10647
2006-03-30 20:29:39 DEBUG: pid 10648: I am 10648
2006-03-30 20:29:39 DEBUG: pid 10649: I am 10649
2006-03-30 20:29:39 DEBUG: pid 10650: I am 10650
2006-03-30 20:29:39 DEBUG: pid 10651: I am 10651
2006-03-30 20:29:39 DEBUG: pid 10652: I am 10652
2006-03-30 20:29:39 DEBUG: pid 10653: I am 10653
2006-03-30 20:29:39 DEBUG: pid 10654: I am 10654
2006-03-30 20:29:39 DEBUG: pid 10655: I am 10655
2006-03-30 20:29:39 LOG:   pid 10623: pgpool successfully started
2006-03-30 20:29:39 LOG:   pid 10623: starting health checking
2006-03-30 20:30:40 LOG:   pid 10623: starting health checking
2006-03-30 20:31:40 LOG:   pid 10623: starting health checking
2006-03-30 20:32:41 LOG:   pid 10623: starting health checking
2006-03-30 20:33:10 DEBUG: pid 10655: I am 10655 accept fd 6
2006-03-30 20:33:10 DEBUG: pid 10655: Protocol Major: 3 Minor: 0 database:
edb_master user: enterprisedb
2006-03-30 20:33:11 DEBUG: pid 10655: pool_read_message_length: lenghth: 8
2006-03-30 20:33:11 ERROR: pid 10655: read_kind: kind does not match between
backends master(83) secondary(69)
2006-03-30 20:33:11 ERROR: pid 10655: pool_do_auth: failed to read kind before
backendkeydata
2006-03-30 20:33:42 LOG:   pid 10623: starting health checking
2006-03-30 20:34:44 LOG:   pid 10623: starting health checking
2006-03-30 20:35:45 LOG:   pid 10623: starting health checking
2006-03-30 20:36:45 LOG:   pid 10623: starting health checking

***********************************************

-------------------------------------------------
This mail sent through IMP: www.resolution.com