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"
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 |