Hi all,
I dont know what else to check.It seems that every time I reload my settings I'm getting the next error for all connections to all my databases :
2018-07-25 10:13:07 IDTLOG: received SIGHUP, reloading configuration files
2018-07-25 10:13:08 IDTsonarusrsonarERROR: invalid value for parameter "client_encoding": "ISO_8859_8"
2018-07-25 10:13:08 IDTsonarusrsonarDETAIL: Cannot change "client_encoding" now.
2018-07-25 10:13:08 IDTbitbucketuserbitbucketERROR: invalid value for parameter "client_encoding": "ISO_8859_8"
2018-07-25 10:13:08 IDTbitbucketuserbitbucketDETAIL: Cannot change "client_encoding" now.
2018-07-25 10:13:08 IDTbitbucketuserbitbucketERROR: invalid value for parameter "client_encoding": "ISO_8859_8"
2018-07-25 10:13:08 IDTbitbucketuserbitbucketDETAIL: Cannot change "client_encoding" now.
2018-07-25 10:13:08 IDTbitbucketuserbitbucketERROR: invalid value for parameter "client_encoding": "ISO_8859_8"
2018-07-25 10:13:08 IDTbitbucketuserbitbucketDETAIL: Cannot change "client_encoding" now.
Any idea what can it be ?
2018-07-15 10:26 GMT+03:00 Mariel Cherkassky <mariel.cherkassky@xxxxxxxxx>:
Hi guys,Any idea what else can I check ? it seems client_encoding isnt set or is default when I query pg_file_settings.2018-07-11 17:49 GMT+03:00 Mariel Cherkassky <mariel.cherkassky@xxxxxxxxx>:postgres=# select * from pg_file_settings where name = 'client_encoding';sourcefile | sourceline | seqno | name | setting | applied | error------------+------------+-------+------+---------+--------- +------- nothing..2018-07-11 17:46 GMT+03:00 Tom Lane <tgl@xxxxxxxxxxxxx>:... btw, another possible aid is
select * from pg_file_settings where name = 'client_encoding';
https://www.postgresql.org/docs/current/static/view-pg-file- settings.html
regards, tom lane
