Psql -> cyrillic characters, CTRL+R, ...

[ogolovanov]

Hello.

If i run psql command via
docker run --rm -ti postgres:9.6 psql '-hxxx.xxx.xxx.xxx' 'database' 'login'
i can not enter russian characters and i can not search through history via CTRL+R combination.

But if i build following image and run the same command - i will be able to enter russian characters and use CTRL+R.

I really can't get how can that be possible.
Why your image does not allow that?
Thanks.

FROM debian:jessie
RUN apt-get update && apt-get install -y locales locales-all postgresql-client
ENV LANG en_US.UTF-8

[tianon]

We set LANG appropriately by default (

postgres/Dockerfile-debian.template

Lines 31 to 34 in 0f55625

	# make the "en_US.UTF-8" locale so postgres will be utf-8 enabled by default
	RUN apt-get update && apt-get install -y locales && rm -rf /var/lib/apt/lists/* \
	&& localedef -i en_US -c -f UTF-8 -A /usr/share/locale/locale.alias en_US.UTF-8
	ENV LANG en_US.utf8

), so I'm not sure why this occurs with our image and not the simple version you've created. 😕

[ogolovanov]

Hello.

Problem is here:
"ENV PATH /usr/lib/postgresql/$PG_MAJOR/bin:$PATH"

So, psql command from /usr/lib/postgresql/9.6/bin/psql used instead of /usr/bin/psql.
The second one works correctly, the first - not.

[MrYoda]

Have the same issue with command (on running container based on postgres:9.5-alpine):
docker exec -it --user postgres postgres-test psql
I can not type or paste any non-ascii symbol. How can I fix it?

[tianon]

Sorry, I think this got lost at some point. 😞

I've opened #355, which should hopefully fix this. 👍