Thread: Segfault : PostgreSQL 9.0.0 and PgPool-II.
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"
On 10/08/2010 09:47 AM, Ugo PARSI wrote: > 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 > From here: http://pgpool.projects.postgresql.org/pgpool-II/doc/pgpool-en.html#restriction Did you follow procedure under ?: Authentication Access Controls -- Adrian Klaver adrian.klaver@gmail.com
Hello, Thank you for your answer. For my simple test, I was only using pgPool-II in front of a single PgSQL server with nothing configured. I've just followed the basic installation guide of pgPool-II. From what I understand from the documentation you're referring me too, it should work in my case : "In all the other modes, trust, clear text password, crypt, md5, pam methods are supported." But I'm going to try that anyway and keep you in touch. - Masquer le texte des messages précédents - Greetings, Ugo PARSI
Still no luck :/ I made it work though by putting everything in "trust" in pg_hba.conf.... but it's not really secure :)
On Friday 15 October 2010 7:26:34 am Ugo PARSI wrote: > Hello, > > Thank you for your answer. > > For my simple test, I was only using pgPool-II in front of a single > PgSQL server with nothing configured. > I've just followed the basic installation guide of pgPool-II. In your original message you said you where setting up replication, hence the reference to pool_password. At the project site: http://pgfoundry.org/projects/pgpool/ There is already a bug filed for Authentication segfault: http://pgfoundry.org/tracker/index.php?func=detail&aid=1010850&group_id=1000055&atid=298 You might want to second the motion :) > > From what I understand from the documentation you're referring me too, > it should work in my case : > "In all the other modes, trust, clear text password, crypt, md5, pam > methods are supported." > > But I'm going to try that anyway and keep you in touch. > - Masquer le texte des messages précédents - > > Greetings, > > Ugo PARSI -- Adrian Klaver adrian.klaver@gmail.com