Re: [GENERAL] Problems with a custom LOCALE

2012-12-16 Thread Tom Lane
"James B. Byrne" writes: >>> PG::Error: ERROR: encoding "UTF8" does not match locale >>> "en...@-mmm-dd.utf-8" >>> DETAIL: The chosen LC_CTYPE setting requires encoding "LATIN1". > This is what I see on the host running postgresql-9.2 > # LC_ALL=en_CA@-mmm-dd.utf8 locale charmap > UTF-8

Re: [GENERAL] Problems with a custom LOCALE

2012-12-16 Thread James B. Byrne
On Fri, December 14, 2012 17:40, Tom Lane wrote: > "James B. Byrne" writes: >> PG::Error: ERROR: encoding "UTF8" does not match locale >> "en...@-mmm-dd.utf-8" >> DETAIL: The chosen LC_CTYPE setting requires encoding "LATIN1". >> : CREATE DATABASE "hll_th_forex_test" ENCODING = 'UTF8' TEMPL

Re: [GENERAL] Problems with a custom LOCALE

2012-12-14 Thread Tom Lane
"James B. Byrne" writes: > PG::Error: ERROR: encoding "UTF8" does not match locale > "en...@-mmm-dd.utf-8" > DETAIL: The chosen LC_CTYPE setting requires encoding "LATIN1". > : CREATE DATABASE "hll_th_forex_test" ENCODING = 'UTF8' TEMPLATE = > "template1" > I am constructing this remotely u

[GENERAL] Problems with a custom LOCALE

2012-12-14 Thread James B. Byrne
Having got the 9.2 instance running in parallel with the previous version I am now encountering this difficulty: Couldn't create database for {"adapter"=>"postgresql", "collate"=>"en_US.UTF-8", "ctype"=>"en_US.UTF-8", "encoding"=>"UTF8", "database"=>"hll_th_forex_development", "host"=>"inet01.hami