[Pgpool-general] RE : pool_do_auth: failed to read kind while processing ParamterStatus

[sergey kapustin]

Thanks for the replay, Aitali but it doesn't work for me regardless the
replication_strict.
is it possible that 8.0 and 8.1 can't work properly together?

On 6/8/07, aitali lahcen <aitali.lahcen at yahoo.fr> wrote:
>
> hi,
> I think that you must do that:
>
> replication_strict = false,
>
> regards
>
> *sergey kapustin <master.sergey at gmail.com>* a écrit :
>
> Hello!
> i'm running pgpool in replication mode on 2 machines:
> 1 - gentoo, postgresql 8.0.4 (master)
> 2 - debian, postgresql 8.1.8 (slave)
>
> ssl mode is set to off both on master and slave.
>
> below is my pgpool.conf and debug. Please help!
> Thank you!
>
> listen_addresses = '*'
> port = 9999
> socket_dir = '/tmp'
> backend_host_name = '192.168.1.254'
> backend_port = 5432
> backend_socket_dir = '/var/run/postgresql'
> secondary_backend_host_name = '192.168.1.99'
> secondary_backend_port = 5432
> num_init_children = 32
> max_pool = 4
> child_life_time = 300
> connection_life_time = 0
> replication_mode = true
> replication_strict = true
>
>
> 2007-06-07 09:23:31 DEBUG: pid 18661: I am 18661 accept fd 6
> 2007-06-07 09:23:31 DEBUG: pid 18661: Protocol Major: 1234 Minor: 5679
> database:  user:
> 2007-06-07 09:23:31 DEBUG: pid 18661: SSLRequest: sent N; retry startup
> 2007-06-07 09:23:31 DEBUG: pid 18661: Protocol Major: 3 Minor: 0 database:
> msgs user: slony
> 2007-06-07 09:23:31 DEBUG: pid 18661: read_message_length: lenghth: 8
> 2007-06-07 09:23:31 DEBUG: pid 18661: read_message_length2: master
> lenghth: 30
> 2007-06-07 09:23:31 DEBUG: pid 18661: name: client_encoding value:
> SQL_ASCII
> 2007-06-07 09:23:31 DEBUG: pid 18661: secondary name: client_encoding
> value: SQL_ASCII
> 2007-06-07 09:23:31 DEBUG: pid 18661: read_message_length2: master
> lenghth: 23
> 2007-06-07 09:23:31 DEBUG: pid 18661: name: DateStyle value: ISO, MDY
> 2007-06-07 09:23:31 DEBUG: pid 18661: secondary name: DateStyle value:
> ISO, MDY
> 2007-06-07 09:23:31 DEBUG: pid 18661: read_message_length2: master
> lenghth: 25
> 2007-06-07 09:23:31 DEBUG: pid 18661: read_message_length2: length does
> not match between backends master(25) secondary(26)
> 2007-06-07 09:23:31 DEBUG: pid 18661: name: integer_datetimes value: on
> 2007-06-07 09:23:31 DEBUG: pid 18661: secondary name: integer_datetimes
> value: off
> 2007-06-07 09:23:31 DEBUG: pid 18661: read_message_length2: master
> lenghth: 20
> 2007-06-07 09:23:31 DEBUG: pid 18661: name: is_superuser value: on
> 2007-06-07 09:23:31 DEBUG: pid 18661: secondary name: is_superuser value:
> on
> 2007-06-07 09:23:31 DEBUG: pid 18661: read_message_length2: master
> lenghth: 30
> 2007-06-07 09:23:31 DEBUG: pid 18661: name: server_encoding value:
> SQL_ASCII
> 2007-06-07 09:23:31 DEBUG: pid 18661: secondary name: server_encoding
> value: SQL_ASCII
> 2007-06-07 09:23:31 DEBUG: pid 18661: read_message_length2: master
> lenghth: 25
> 2007-06-07 09:23:31 DEBUG: pid 18661: name: server_version value: 8.1.8
> 2007-06-07 09:23:31 DEBUG: pid 18661: secondary name: server_version
> value: 8.0.4
> 2007-06-07 09:23:31 DEBUG: pid 18661: read_message_length2: master
> lenghth: 32
> 2007-06-07 09:23:31 DEBUG: pid 18661: name: session_authorization value:
> slony
> 2007-06-07 09:23:31 DEBUG: pid 18661: secondary name:
> session_authorization value: slony
> 2007-06-07 09:23:31 DEBUG: pid 18661: read_message_length2: master
> lenghth: 36
> 2007-06-07 09:23:31 DEBUG: pid 18661: read_message_length2: length does
> not match between backends master(36) secondary(17)
> 2007-06-07 09:23:31 DEBUG: pid 18661: name: standard_conforming_strings
> value: off
> 2007-06-07 09:23:31 DEBUG: pid 18661: secondary name: TimeZone value: GMT
> 2007-06-07 09:23:31 ERROR: pid 18661: read_kind: kind does not match
> between backends master(83) secondary(75)
> 2007-06-07 09:23:31 ERROR: pid 18661: pool_do_auth: failed to read kind
> while processing ParamterStatus
>
> _______________________________________________
> Pgpool-general mailing list
> Pgpool-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-general
>
>
> ------------------------------
> Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions
> ! Profitez des connaissances, des opinions et des expériences des
> internautes sur Yahoo! Questions/Réponses<http://fr.rd.yahoo.com/evt=42054/*http://fr.answers.yahoo.com>
> .
>
> ------------------------------
> Stockage illimité de vos mails avec Yahoo! Mail. Changez aujourd'hui de
> mail ! <http://fr.promotions.yahoo.com/mail/nouveau_yahoomail2.html>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://pgfoundry.org/pipermail/pgpool-general/attachments/20070608/674bae26/attachment.html