[Pgpool-general] stuck when running in daemon mode + pool_hba md5 authentication

Asaf asaf at lingnu.com
Wed Oct 20 17:42:22 UTC 2010


  pgpool 3.0.1 / postgresql 9.0.1 / CentOS release 5.5

a strange difference in behavior:
when running pgpool -d -n works OK,
but when running in daemon mode (no -n) psql gets stuck forever.

the log's tail:
2010-10-20 19:34:08 DEBUG: pid 10665: key: ssl
2010-10-20 19:34:08 DEBUG: pid 10665: value: false kind: 1
2010-10-20 19:34:08 DEBUG: pid 10665: key: debug_level
2010-10-20 19:34:08 DEBUG: pid 10665: value: 0 kind: 2
2010-10-20 19:34:08 DEBUG: pid 10665: loading 
"/etc/pgpool-II//pool_hba.conf" for client authentication configuration file
2010-10-20 19:34:08 DEBUG: pid 10665: shmem_exit(0)

after running, no additional lines when invoking 'psql'

the log looks quite different when running with '-n':

2010-10-20 19:42:25 DEBUG: pid 10859: value: 0 kind: 2
2010-10-20 19:42:25 DEBUG: pid 10859: loading 
"/etc/pgpool-II//pool_hba.conf" for client authentication configuration file
2010-10-20 19:42:25 DEBUG: pid 10860: I am 10860
2010-10-20 19:42:25 DEBUG: pid 10861: I am 10861
2010-10-20 19:42:25 DEBUG: pid 10862: I am 10862
..
..
..
2010-10-20 19:42:25 LOG:   pid 10859: pgpool-II successfully started. 
version 3.0.1 (umiyameboshi)
2010-10-20 19:42:25 DEBUG: pid 10888: I am 10888
2010-10-20 19:42:25 DEBUG: pid 10893: I am 10893


also, there is no problem when not using pool_hba md5 authentication

-- 
Asaf Ohaion
Lingnu Open Source Consulting Ltd.
http://www.lingnu.com



More information about the Pgpool-general mailing list