geohacker/pg_locales.md

## pg_locales.md

      
    Raw
  

              pg_locales.md
            
          
    Add this to ~/.profile -
export LANGUAGE="en_US.UTF-8"
export LANG="en_US.UTF-8"
export LC_ALL="en_US.UTF-8"


Run source ~/.profile
sudo su postgres psql
update pg_database set datistemplate=false where datname='template1';
drop database Template1;
create database template1 with owner=postgres encoding='UTF-8' lc_collate='en_US.utf8' lc_ctype='en_US.utf8' template template0;
update pg_database set datistemplate=true where datname='template1';