[Pgpool-general] having problem running pgpool-II

[Tatsuo Ishii]

I assume you can execute "select count(id) from dbuser" via psql.

Can you show me pgpool's debug log? i.e. Start pgpool with -d option.
--
Tatsuo Ishii
SRA OSS, Inc. Japan

> Hi,
> I am having problem running pgpool-II. I am running
> [ 2.6.15-1.2054_FC5 #1 SMP Tue Mar 14 15:48:20 EST 2006 x86_64 x86_64 x86_64
> GNU/Linux ]
> and enterprisedb 8.1.4.17
> I did ./configure, make, and makeinstall for pgpool=II 1.0.1.
> It seems I can login after I started pgppol as
> [ ./edb-psql -h NODE1 -p 9999 -U edb development ]
> 
> But I cannot get a result from simple query which TestPgpool.java runs
> [ Connection con = DriverManager.getConnection("jdbc:edb://IP:9999/development",
> "edb","edb"); ]
> Program comes to line below but cannot get the result set (no error)
> [ ResultSet postgresRs = postgresStmt.executeQuery("select count(id) from
> dbuser"); ]
> 
> I cannot figure it out what I am missing or what I had done wrong?
> Below is the my config files. I am attempting to use as in load balance mode
> -------pcp.conf----------------
> # USERID:MD5PASSWD
> 
> #pg_md5 enterprisedb
> enterprisedb:891380f05b138eb6aa16260ca67d3bf3
> #enterprisedb:enterprisedb
> -------pgpool.conf-------------
> #listen_addresses = 'localhost'
> #listen_addresses = '*'
> listen_addresses = 'baba1'
> port = 9999
> pcp_port = 9898
> socket_dir = '/var/run'
> pcp_socket_dir = '/var/run'
> backend_socket_dir = '/tmp'
> pcp_timeout = 10
> num_init_children = 32
> max_pool = 4
> child_life_time = 300
> connection_life_time = 0
> child_max_connections = 0
> logdir = '/tmp'
> replication_mode = false
> replication_strict = true
> replication_timeout = 5000
> load_balance_mode = true
> replication_stop_on_mismatch = false
> reset_query_list = 'ABORT; RESET ALL; SET SESSION AUTHORIZATION DEFAULT'
> print_timestamp = true
> master_slave_mode = true
> connection_cache = true
> health_check_timeout = 20
> health_check_period = 0
> health_check_user = 'nobody'
> insert_lock = false
> ignore_leading_white_space = false
> log_statement = true
> parallel_mode = false
> enable_query_cache = false
> pgpool2_hostname = ''
> 
> # system DB info
> system_db_hostname = 'localhost'
> system_db_port = 5444
> system_db_dbname = 'pgpool'
> system_db_schema = 'pgpool_catalog'
> system_db_user = 'pgpool'
> system_db_password = ''
> 
> # backend_hostname, backend_port, backend_weight
> # here are examples
> backend_hostname0 = 'baba1'
> backend_port0 = 5444
> backend_weight0 = 1
> backend_hostname1 = 'baba2'
> backend_port1 = 5444
> backend_weight1 = 1
> -----------------------
> thanks for help
> 
> -------------------------------------------------
> This mail sent through IMP: www.resolution.com
> _______________________________________________
> Pgpool-general mailing list
> Pgpool-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-general
>