[Pgpool-general] Small change for v3 formatted ErrorResponce handling.
Tatsuo Ishii
ishii at sraoss.co.jp
Sun Aug 27 00:13:01 UTC 2006
Thnaks! I will look into your patches.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
> Hi Ishii San,
>
>
> In my environment(pgpool 3.1.1 on RHEL4 with two backend PostgreSQL
> 8.1.14 and 7.3.14), I noticed frontend reports following message, when
> backend pg_hba.conf rejects a connection and sends v3 formatted
> ErrorResponce.
>
> [frontend message]
> $ psql -p 9999 -d test
> psql: server closed the connection unexpectedly
> This probably means the server terminated abnormally
> before or while processing the request.
>
> [backend log]
> $ tail -f /usr/local/pgsql/data/pg_log/postgresql-2006-08-26_194414.log
> ...
> FATAL: no pg_hba.conf entry for host "131.248.226.93", user "postgres",
> database "test", SSL off
>
>
> To forward v3 formatted ErrorResponce, I added two small functions.
> Please find my attachment. The idea for themodification is from
> libpq/fe-connect.c in PostgreSQL 8.1.4. I believe this change helps
> frontend programs.
>
>
> Thank you,
> Kenji Kikuchi
>
>
> --
> ITOCHU TECHNO-SCIENCE Corporation
>
> Kenji Kikuchi
>
> TEL:03-6203-3804 FAX:03-5512-3026
> E-mail: kenji.kikuti at ctc-g.co.jp
>
> ---------------------------------
More information about the Pgpool-general
mailing list