[Pgpool-general] read_message_length problems

[Tatsuo Ishii]

> > Hi
> > I have a problem with connecting two postmasters (separate server) from 
> > pgpool.
> > and I have error messages shown below.
> > 
> > >2005-10-12 15:44:23 DEBUG: pid 21207: I am 21207 accept fd 6
> > >2005-10-12 15:44:23 DEBUG: pid 21207: Protocol Major: 1234 Minor: 5679 
> > >database:  user:
> > >2005-10-12 15:44:23 DEBUG: pid 21207: SSLRequest: sent N; retry startup
> > >2005-10-12 15:44:23 DEBUG: pid 21207: Protocol Major: 3 Minor: 0 database: 
> > >nittel user: nittel
> > >2005-10-12 15:44:23 DEBUG: pid 21207: connecting postmaster Unix domain 
> > >socket: /tmp/.s.PGSQL.5432
> > >2005-10-12 15:44:23 DEBUG: pid 21207: connected to postmaster Unix domain 
> > >socket: /tmp/.s.PGSQL.5432 fd: 7
> > >2005-10-12 15:44:23 DEBUG: pid 21207: read_message_length: lenghth: 12
> > >2005-10-12 15:44:23 ERROR: pid 21207: read_message_length: length does not 
> > >match between backends master(12) secondary(8)
> > 
> > Also from other thread,  it was the same time zone of two servers....
> > it seems that responses of read_message_length from two postmasters do not 
> > match. does that mean what??
> > please advice me...
> 
> Can you turn on debug mode (-d) and show me the messages?

Oops. You have already sent the debug out message.

My guess from the message is:

1) your database encodings are different among servers
2) you are using older version of pgpool. pgpool 2.6 or greater
   can handle different encoding, time zone settings..
--
SRA OSS, Inc. Japan
Tatsuo Ishii