encoding UTF8 does not match locale en_US; the chosen LC_CTYPE setting requires encoding LATIN1
I combined two solutions from other sites that did the job (this answer works for Ubuntu server 12.04 and PGSQL 9.1): Create a file: nano /etc/profile.d/lang.sh. Add the following: export LANGUAGE=”en_US.UTF-8″ export LANG=”en_US.UTF-8″ export LC_ALL=”en_US.UTF-8″ Save the file Restart the shell or run all export commands manually in current shell instance Reconfigure so the encoding … Read more