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.?
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
