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
