[Pgpool-general] PGPool II Replication Mode Fails

[Tatsuo Ishii]

It seems some PostgreSQL settings, for example super user name, server
encoding etc., do not agree among two servers. Can you enable the
debug option (-d) of pgpool-II and show the debug messages around the
error message?
--
Tatsuo Ishii
SRA OSS, Inc. Japan

> 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
> 
> _______________________________________________
> Pgpool-general mailing list
> Pgpool-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-general