Re: [pgpool-general: 6154] invalid value for parameter "client_encoding": "ISO_8859_8"

From: Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>
To: mariel(dot)cherkassky(at)gmail(dot)com
Cc: pgpool-general(at)pgpool(dot)net, pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: [pgpool-general: 6154] invalid value for parameter "client_encoding": "ISO_8859_8"
Date: 2018-07-01 23:15:03
Message-ID: 20180702.081503.1606743649925349289.t-ishii@sraoss.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> Hi,
> My postgresql env consist of 3 nodes(9.6 version) and 2 pgpool`s that acts
> as a load balancer. I'm using postgresql as a database for the next apps :
> bitbucket,jira and crowd. However, I'm getting alot of errors in the pgpool
> log about the client_encoding for every connection that comes from one of
> those application :
>
> invalid value for parameter "client_encoding": "ISO_8859_8"
> Cannot change "client_encoding" now.
>
> The client_encoding is set to default in the database.
>
> Any idea what can I check ? I dont think that it is something of the
> application layer. The encoding of all those databases is UTF8 and the
> collate and ctype is en_US.UTF-8.
>
> I want to get the idea if the error connected to the app level / pool level
> / database level ?

It's database level. I suggest you try to connect your application
without Pgpool-II, and check to see if you still get the error message.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Heinemann, Manfred (IMS) 2018-07-02 18:27:43 RE: Segmentation fault with parallelism PG 10.4
Previous Message Tom Lane 2018-07-01 15:33:16 Re: invalid value for parameter "client_encoding": "ISO_8859_8"