[Pgpool-general] problem connecting through pgpool

Tatsuo Ishii ishii at sraoss.co.jp
Mon Sep 10 09:17:45 UTC 2007


My guess is, you have trust authentication(i.e. no password) for
backend 0, while backend 1 uses md5 or some other password auth
methods. You need to use same auth method for all DBs and the auth
method must be one of trust, clear text password and pam.
--
Tatsuo Ishii
SRA OSS, Inc. Japan

> I have configured pgpool-II in replication mode, and when I attempt to connect through pgpool to either of the 2 databases, I get this error:
> 
> 2007-09-10 00:24:46 DEBUG: pid 8204: new_connection: connecting 0 backend
> 2007-09-10 00:24:46 DEBUG: pid 8204: new_connection: connecting 1 backend
> 2007-09-10 00:24:46 DEBUG: pid 8204: pool_read_message_length: slot: 0 length: 12
> 2007-09-10 00:24:46 DEBUG: pid 8204: pool_read_message_length: slot: 1 length: 8
> 2007-09-10 00:24:46 ERROR: pid 8204: pool_read_message_length: message length (8) in slot 1 does not match with slot 0
> 
> Can anyone explain what is happening and give any advice to resolve this?
> 
> Thanks,
> 
> Peter Vallero
> Database Administrator


More information about the Pgpool-general mailing list