[Pgpool-general] pgpool and c3p0 quession

[王彬德]

   Dear  all:

             i have install pgpool-II-3.1.0-alpha1 in centos system.architecture is :

     |_________|

     | tomcat  |

     |  c3po   |

     |_________|

          |

          |

     |_________|

     |pgpool   |

     |_________|

          |

     |_________|

     |db1  db2 |

     |_________|

  that  db1 and  db2 have two table ,it's data is different.

the first table select use jdbc can access diferent data,the second table select use conection pool c3p0 dose't acess different data.that my mean is c3p0 connection pool can't accomplish load balance in db1 and db2.can you help me?

  my pgpool.conf is :

listen_addresses = '*'

port = 5432

pcp_port = 9898

socket_dir = '/tmp'

pcp_socket_dir = '/tmp'

backend_socket_dir = '/tmp'

pcp_timeout = 10

num_init_children = 32

max_pool = 4

child_life_time = 3

connection_life_time = 3

child_max_connections = 0

client_idle_limit = 0

authentication_timeout = 60

logdir = '/tmp'

pid_file_name = '/var/run/pgpool/pgpool.pid'

replication_stop_on_mismatch = false

failover_if_affected_tuples_mismatch = false

replicate_select = false

reset_query_list = 'ABORT; DISCARD ALL'

white_function_list = ''

black_function_list = 'nextval,setval'

print_timestamp = true

#master_slave_mode = true

replication_mode = true

load_balance_mode = true

#master_slave_sub_mode = 'stream'

delay_threshold = 0

log_standby_delay = 'none'

connection_cache = false

health_check_timeout = 20

health_check_period = 3

health_check_user = 'postgres'

failover_command = ''

failback_command = ''

fail_over_on_backend_error = true

insert_lock = true

ignore_leading_white_space = true

log_statement = false

log_per_node_statement = false

log_connections = false

log_hostname = false

parallel_mode = false

enable_query_cache = false

pgpool2_hostname = ''

system_db_hostname = 'localhost'

system_db_port = 5432

system_db_dbname = 'pgpool'

system_db_schema = 'pgpool_catalog'

system_db_user = 'pgpool'

system_db_password = ''

backend_hostname0 = '192.168.1.118'

backend_port0 = 5434

backend_weight0 = 1

backend_hostname1 = '192.168.1.205'

backend_port1 = 5433

backend_weight1 = 1

enable_pool_hba = false

recovery_user = 'nobody'

recovery_password = ''

recovery_1st_stage_command = ''

recovery_2nd_stage_command = ''

recovery_timeout = 90

client_idle_limit_in_recovery = 0

lobj_lock_table = ''

ssl = false

debug_level = 0

  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20110109/2a6378f1/attachment-0001.html>