[Pgpool-general] having problem running pgpool-II

gurkan at resolution.com gurkan at resolution.com
Thu Dec 7 18:36:35 UTC 2006


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


More information about the Pgpool-general mailing list