[Pgpool-general] Error "kind does not match between backends"

[Tatsuo Ishii]

You need to sync PostgreSQL version of master and slave.

BTW, pgpool 2.6.3 is a little bit old. The latest verison of pgpool is
2.7.2.
--
Tatsuo Ishii
SRA OSS, Inc. Japan

> Hello!
> 
> I just tried to setup pgpool-2.6.3 for two servers in master/slave mode.
> Connection via pgpool fails:
> 
> root at sql:~#psql -U vap -p 9999 -h sql3 infopac
> Password:
> psql: server closed the connection unexpectedly
>          This probably means the server terminated abnormally
>          before or while processing the request.
> 
> Pgpool.log contains the following diagnostics:
> 
> 2006-02-02 13:01:24 DEBUG: pid 77219: name: session_authorization value: vap
> 2006-02-02 13:01:24 DEBUG: pid 77219: secondary name: server_encoding 
> value: UNICODE
> 2006-02-02 13:01:24 ERROR: pid 77219: read_kind: kind does not match 
> between backends master(75) secondary(83)
> 2006-02-02 13:01:24 ERROR: pid 77219: pool_do_auth: failed to read kind 
> while processing ParamterStatus
> 
> Master server has version 7.4.11, slave has version 8.0.6. Slave 
> contains the replication of the only one schema from master. Replication 
> implemented via slony1-1.1.2. Both servers has equal authentification 
> settings:
> 
> Master:
>    host all all 217.77.96.0 255.255.255.0 password
> Slave:
>    host all all 217.77.96.0/24 password
> 
> Configuration of pgpool:
> 
> listen_addresses = '*'
> port = 9999
> socket_dir = '/tmp'
> backend_host_name = 'sql.infopac.ru'
> backend_port = 5432
> secondary_backend_host_name = 'sql3.infopac.ru'
> secondary_backend_port = 5432
> num_init_children = 32
> max_pool = 4
> child_life_time = 300
> connection_life_time = 0
> logdir = '/var/log'
> replication_mode = false
> replication_strict = true
> replication_timeout = 5000
> load_balance_mode = true
> weight_master = 1
> weight_secondary = 10
> replication_stop_on_mismatch = false
> reset_query_list = 'ABORT; RESET ALL; SET SESSION AUTHORIZATION DEFAULT'
> print_timestamp = true
> master_slave_mode = true
> connection_cache = true
> health_check_timeout = 20
> health_check_period = 0
> health_check_user = 'nobody'
> insert_lock = false
> 
> How can I to resolve this problem?
> Any help will be appreciated.
> 
> -- 
> Vladimir A. Petrov (aka vap)                    phone: (+7 8482) 420069
> Infopac JSC. Head of the exploitation department.     http://infopac.ru
> _______________________________________________________________________
> ^[:wq                                         ...sed libera nos a malo.
> 
> _______________________________________________
> Pgpool-general mailing list
> Pgpool-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-general
>