Segfault : PostgreSQL 9.0.0 and PgPool-II.

From: Ugo PARSI <ugo(dot)parsi(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Segfault : PostgreSQL 9.0.0 and PgPool-II.
Date: 2010-10-08 16:47:06
Message-ID: AANLkTi=XevEoRzi3m0gT52C3_NSGaNPHMWxOMPrCRMTx@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)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(at)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(at)test-pgsql:/usr/src/pgpool-II-3.0#

root(at)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"

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2010-10-08 17:29:01 Re: Segfault : PostgreSQL 9.0.0 and PgPool-II.
Previous Message Tom Lane 2010-10-08 14:40:25 Re: Optimization of FK creation