Re: [HACKERS] locale problem of bgworker: logical replicationlauncher and worker process

Thanks for reply.

I resolved this problem.

This problem is that dgettext() function use codeset of database's lc_ctype.

below database's lc_ctype is C, but locale is ko_KR.UTF8.

I made a new database with lc_ctype is ko_KR.UTF8.

this problem is resolved.

----

work logs are here.


(10) postgres@postgres=# \l                               데이터베이스 목록   이름    |  소유주  | 인코딩 | Collate |    Ctype    |
액세스 권한
 
-----------+----------+--------+---------+-------------+----------------------- krdb      | postgres | UTF8   | C
|ko_KR.UTF-8 | postgres  | postgres | UTF8   | C       | C           | template0 | postgres | UTF8   | C       | C
    | 
 
=c/postgres          +           |          |        |         |             | 
postgres=CTc/postgres template1 | postgres | UTF8   | C       | C           | 
=c/postgres          +           |          |        |         |             | 
postgres=CTc/postgres
(4개 행)

(10) postgres@postgres=# \c
접속정보: 데이터베이스="postgres", 사용자="postgres".
(10) postgres@postgres=# create subscription sub1 connection 
'host=127.0.0.1 port=5432 client_encoding=C' publication pub1;
2017-08-25 18:13:34.556 KST [5401] 오류:  발행 서버에 연결 할 수 없음: ??? 
??? ? ??: ??? ???        "127.0.0.1" ???? ??? ?? ???,        5432 ??? TCP/IP ??? ???? ??????.
2017-08-25 18:13:34.556 KST [5401] 명령 구문:  create subscription sub1 
connection 'host=127.0.0.1 port=5432 client_encoding=C' publication pub1;
오류:  발행 서버에 연결 할 수 없음: ??? ??? ? ??: ??? ???    "127.0.0.1" ???? ??? ?? ???,    5432 ??? TCP/IP ??? ???? ??????.
(10) postgres@postgres=# \c krdb
접속정보: 데이터베이스="krdb", 사용자="postgres".
(10) postgres@krdb=# create subscription sub1 connection 'host=127.0.0.1 
port=5432 client_encoding=C' publication pub1;
2017-08-25 18:13:45.687 KST [5402] 오류:  발행 서버에 연결 할 수 없음: 
서버에 연결할 수 없음: 연결이 거부됨        "127.0.0.1" 호스트에 서버가 가동 중인지,        5432 포트로 TCP/IP 연결이 가능한지 살펴보십시오.
2017-08-25 18:13:45.687 KST [5402] 명령 구문:  create subscription sub1 
connection 'host=127.0.0.1 port=5432 client_encoding=C' publication pub1;
오류:  발행 서버에 연결 할 수 없음: 서버에 연결할 수 없음: 연결이 거부됨    "127.0.0.1" 호스트에 서버가 가동 중인지,    5432 포트로 TCP/IP 연결이 가능한지 살펴보십시오.


2017년 08월 23일 22:40에 Peter Eisentraut 이(가) 쓴 글:
> On 8/22/17 01:19, Ioseph Kim wrote:
>> 2017-08-22 14:06:21.697 KST [306] 로그:  logical replication apply
>> worker for subscription "replica_a" has started
>> 2017-08-22 14:06:21.698 KST [306] 오류:  발행 서버에 연결 할 수 없음:
>> ??? ??? ? ??: ??? ???
>>          "localhost" (::1) ???? ??? ?? ???,
>>          5432 ??? TCP/IP ??? ???? ??????.
>>      ??? ??? ? ??: ??? ???
>>          "localhost" (127.0.0.1) ???? ??? ?? ???,
>>          5432 ??? TCP/IP ??? ???? ??????.
>> -----
>>
>> main postmaster messages are printed  in korean well,
>> but bgworker process message is not.
>>
>> This problem seems to have occurred because the server locale
>> environment and the client's that are different.
> I have tried it locally with a ko_KR locale, and it seems to work
> correctly for me.  Still, I can imagine there are all kinds of ways this
> could go wrong in particular configurations.  Could you construct a
> reproducible test setup, including specific initdb and locale settings,
> operating system, etc.?
>