Hello,
I'm having issues trying to set up PgPool-II with PostgreSQL 9.0.0
(for HA reasons with Streaming Replication).
PgPool end up with a SIGSEV whenever I have a correct authentification.
To try my set up, I've installed a default PgSQL 9.0.0 server, where I
can connect without a single problem.
root@test-pgsql:/# psql -h localhost -p 5432 -U postgres
Password for user postgres:
psql (9.0.0)
SSL connection (cipher: DHE-RSA-AES256-SHA, bits: 256)
Type "help" for help.
postgres=# \q
But whenever I try to connect to the PgPool port ... the PgPool
process dies at the moment I enter the valid password.
root@test-pgsql:/usr/src/pgpool-II-3.0# psql -h localhost -p 9999 -U postgres
Password for user postgres:
psql: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
root@test-pgsql:/usr/src/pgpool-II-3.0#
root@test-pgsql:~# pgpool -n
2010-10-08 16:42:13 LOG: pid 14248: pgpool-II successfully started.
version 3.0 (umiyameboshi)
2010-10-08 16:42:18 ERROR: pid 14280: do_md5: read_password_packet failed
2010-10-08 16:42:20 ERROR: pid 14248: Child process 14280 was
terminated by segmentation fault
Do you have any idea ? (I've followed the basic PgPool-II instructions
for the installation part)
Is there any other way to achieve some kind of HA with Streaming-Replication ?
Some kind of best-practices ?
Thanks a lot,
Greetings,
Ugo PARSI
--
"Above, the stars are spiralling
and Heaven, Earth are roaming in a spin"