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@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
