Re: Segfault : PostgreSQL 9.0.0 and PgPool-II.

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

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(dot)klaver(at)gmail(dot)com