[Pgpool-general] PGPool II Replication Mode Fails

[David Jantzen]

Hello, thanks for the help.  It looks like there was an authentication
problem to the secondary server, and I have verified that I can now
connect to the secondary server as the postgres user.

However, now I see in /var/log/syslog:

pool_read_message_length: message length (12) in slot 1 does not match
with slot 0

Any ideas?

Oh, versions:
PostgreSQL 8.2.4
PGPool II 1.2-1

Thanks,
David

On Thu, 2007-09-06 at 10:49 +0900, Yoshiyuki Asaba wrote:
> Hi,
> 
> From: David Jantzen <david.jantzen at comcast.net>
> Subject: [Pgpool-general] PGPool II Replication Mode Fails
> Date: Wed, 05 Sep 2007 17:57:48 -0700
> 
> > However, when I enable replication_mode and try to connect to pgpool
> > I run into an error:
> > 
> > psql -p 9999 -U postgres template1
> > 
> > psql: server closed the connection unexpectedly
> >         This probably means the server terminated abnormally
> >         before or while processing the request.
> > 
> > In /var/log/syslog I see:
> > 
> > pool_read_kind: kind does not match between master(82) slot[1] (69)
> 
> It seems that a client authentication failed on secondary server.
> 
> Could you try the operations on pgpool host?
> 
>   % psql -h master -U postgres template1
>   % psql -h secondary -U postgres template1
> 
> --
> Yoshiyuki Asaba
> y-asaba at sraoss.co.jp