On 2020-04-07 18:41, Don Seiler wrote:
> Follow-up question, the locale setting on the host would still be set to
> en_US (as would the postgres and template0 databases). Should I look to
> change that locale on the system to en_US.UTF-8, or even just for the
> postgres user that the DB cluster runs as? What are the ramification for
> doing (or not doing) so?
I think the only place where this would really matter is that psql by
default sets the client encoding based on the current OS locale setting.
So if you don't change the setting to en_US.UTF-8, then you might get
encoding errors when selecting data that is not representable as LATIN1
or whatever. However, if you change the setting, that doesn't mean your
terminal setup will actually display Unicode correctly. You said you're
dealing with mostly ASCII-ish data anyway, so it will probably not make
a difference.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services