Re: [pgpool-general: 6154] invalid value for parameter"client_encoding": "ISO_8859_8" - Mailing list pgsql-admin

From Tatsuo Ishii
Subject Re: [pgpool-general: 6154] invalid value for parameter"client_encoding": "ISO_8859_8"
Date
Msg-id 20180702.081503.1606743649925349289.t-ishii@sraoss.co.jp
Whole thread Raw
In response to invalid value for parameter "client_encoding": "ISO_8859_8"  (Mariel Cherkassky <mariel.cherkassky@gmail.com>)
List 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


pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: invalid value for parameter "client_encoding": "ISO_8859_8"
Next
From: "Heinemann, Manfred (IMS)"
Date:
Subject: RE: Segmentation fault with parallelism PG 10.4