[Pgpool-general] PGPool II Replication Mode Fails

[Yoshiyuki Asaba]

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