[Pgpool-general] pgpool pghba woes in parallel mode

mobiledreamers at gmail.com mobiledreamers at gmail.com
Sat Jun 27 17:12:22 UTC 2009


i tried trust as method of auth, and sometiems it gives error message length
8 and 12 does not match or read auth kind failed

Please show me how to setup pg_hba for pgpool-II in parallel mode

thanks

pgpool node 26.129.113.181

in all the backend node pg_hba.conf
host    all         all         26.129.113.181 255.255.255.255      trust

in 26.129.113.181
# "local" is for Unix domain socket connections only
local   all         all                               trust
# IPv4 local connections:
host    all         all         127.0.0.1/32          trust

tail -f /tmp/pgpool.log
2009-06-27 10:07:23 LOG:   pid 23935: pgpool successfully started
2009-06-27 10:07:31 ERROR: pid 23937: pool_read_message_length: message
length (12) in slot 2 does not match with slot 0(8)
2009-06-27 10:07:31 ERROR: pid 23937: Failed to read the authentication
packet length. This is likely caused by the inconsistency of auth method
among DB nodes. In this case you can check the previous error messages
(hint: length field) from pool_read_message_length and recheck the
pg_hba.conf settings.
2009-06-27 10:08:22 ERROR: pid 23938: pool_read_message_length: message
length (12) in slot 2 does not match with slot 0(8)
2009-06-27 10:08:22 ERROR: pid 23938: Failed to read the authentication
packet length. This is likely caused by the inconsistency of auth method
among DB nodes. In this case you can check the previous error messages
(hint: length field) from pool_read_message_length and recheck the
pg_hba.conf settings.
2009-06-27 10:08:58 LOG:   pid 23935: received smart shutdown request
tail: /tmp/pgpool.log: file truncated
2009-06-27 10:09:02 ERROR: pid 26198: pool_read_int: data does not match
between between master(0) slot[3] (50331648)
2009-06-27 10:09:02 ERROR: pid 26198: pool_do_auth: read auth kind failed
2009-06-27 10:09:20 LOG:   pid 26192: received smart shutdown request
tail: /tmp/pgpool.log: file truncated
2009-06-27 10:09:24 ERROR: pid 26777: pool_read_int: data does not match
between between master(0) slot[4] (50331648)
2009-06-27 10:09:24 ERROR: pid 26777: pool_do_auth: read auth kind failed
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20090627/97517af3/attachment.html>


More information about the Pgpool-general mailing list