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

[c.y.liu]

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