[Pgpool-general] pgpool-3.0 (3.0.1) doesn't work with postgresql 8.1.18

[Tatsuo Ishii]

It's a known problem with md5 auth. It has been fixed in 3.0.1.
Please use 3.0.1.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> Hi All,
> 
> I install pgpool-II-3.0 and find that it doesn't work with my
> postgresql 8.1.18. following is my environment.
> 
> postgresql-devel-8.1.18-2.el5_4.1
> postgresql-libs-8.1.18-2.el5_4.1
> postgresql-libs-8.1.18-2.el5_4.1
> postgresql-server-8.1.18-2.el5_4.1
> postgresql-devel-8.1.18-2.el5_4.1
> postgresql-8.1.18-2.el5_4.1
> 
> the pgpool-II-3.0 is compiled with following parameters.
> 
> ./configure --with-pgsql-libdir=/usr/lib64/
> --with-pgsql-includedir=/usr/include/pgsql/ --with-openssl --with-pam
> 
> when i try to execute sql using psql, it prompt error message.
> # psql -h localhost -p 9999
> psql: server closed the connection unexpectedly
>         This probably means the server terminated abnormally
>         before or while processing the request.
> 
> also the log of pgpool shows:
> 
> 2010-11-10 21:59:06 DEBUG: pid 11854: I am 11854 accept fd 6
> 2010-11-10 21:59:06 DEBUG: pid 11854: Protocol Major: 1234 Minor: 5679
> database:  user:
> 2010-11-10 21:59:06 DEBUG: pid 11854: SSLRequest from client
> 2010-11-10 21:59:06 DEBUG: pid 11854: Protocol Major: 3 Minor: 0
> database: kusudb user: postgres
> 2010-11-10 21:59:06 DEBUG: pid 11854: new_connection: connecting 0 backend
> 2010-11-10 21:59:06 DEBUG: pid 11854: pool_read_message_length: slot:
> 0 length: 12
> 2010-11-10 21:59:06 DEBUG: pid 11854: trying md5 authentication
> 2010-11-10 21:59:06 DEBUG: pid 11854: DB node id: 0 salt: 1569147
> 2010-11-10 21:59:06 DEBUG: pid 11824: reap_handler called
> 2010-11-10 21:59:06 DEBUG: pid 11824: reap_handler: call wait3
> 2010-11-10 21:59:06 ERROR: pid 11824: Child process 11854 was
> terminated by segmentation fault
> 2010-11-10 21:59:06 DEBUG: pid 11824: child 11854 exits with status 11
> by signal 11
> 2010-11-10 21:59:06 DEBUG: pid 11824: fork a new child pid 11865
> 2010-11-10 21:59:06 DEBUG: pid 11824: reap_handler: normally exited
> 2010-11-10 21:59:06 DEBUG: pid 11865: I am 11865
> 
> BTW, i tried pgpool-II-3.0.1, it has same problems. but
> pgpool-II-2.3.3 works well.
> 
> -- 
> Chunyang Liu
> _______________________________________________
> Pgpool-general mailing list
> Pgpool-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-general