What's the output of the following query on each server?
select name, setting from pg_settings where name ~ '^lc_';
Ahh there's a difference
mydb=# select name, setting from pg_settings where name ~ '^lc_';
name | setting
-------------+---------
lc_collate | en_US
lc_ctype | en_US
lc_messages | en_US
lc_monetary | en_US
lc_numeric | en_US
lc_time | en_US
mydb=# select name, setting from pg_settings where name ~ '^lc_';
name | setting
-------------+---------
lc_collate | C
lc_ctype | C
lc_messages | C
lc_monetary | C
lc_numeric | C
lc_time | C
I guess the reason is that PostgreSQL got installed before setting the
locale,
and the only way to change it is using initdb --locale.
Poul
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
