[Pgpool-general] kind does not match between backends

Fernando Schapachnik fernando at mecon.gov.ar
Tue Mar 15 19:48:32 GMT 2005


Hi,

I'm trying to deploy pgpool 2.5.2 with the following settings:

backend_host_name = ''
backend_port = 5432
secondary_backend_host_name = 'anotherhost'
secondary_backend_port = 5432
load_balance_mode = true
master_slave_mode = true

Localhost is PG 7.3.9, remote is 7.3.8. When I try to connect to pgpool with 
psql everything works OK. However the application (PG Samba backend) issues a 
PQsetdbLogin(). The logs read:

DEBUG: pid 62439: I am 62439 accept fd 6
DEBUG: pid 62439: Protocol Major: 1234 Minor: 5679 database:  user:
DEBUG: pid 62439: SSLRequest: sent N; retry startup
DEBUG: pid 62439: Protocol Major: 2 Minor: 0 database: MYDB user: MYUSER
DEBUG: pid 62439: connecting postmaster Unix domain socket: /tmp/.s.PGSQL.5432
DEBUG: pid 62439: connected to postmaster Unix domain socket: /tmp/.s.PGSQL.5432 fd: 7
ERROR: pid 62439: read_message_kind: kind does not match between backends master(75) secondary(88)

The numbers between parenthesis vary. Note the extrange protocol number in the 
second line, as well as the empty database and user.

Any ideas?

Thanks & regards,

Fernando.


More information about the Pgpool-general mailing list