Hi Vincent
I ran a few tests, using:
cat /etc/default/locale
# File generated by update-locale
LANG="en_AU.UTF-8"
LANGUAGE="en_AU:en"
No problems showed up.
On 07/04/14 03:59, Vincent Veyron wrote:
On Sun, 6 Apr 2014 16:01:54 -0000
"Greg Sabino Mullane" <g...@turnstep.com> wrote:
What are server_encoding and client_encoding set to on each database?
Hi Greg,
Same thing for both servers:
ppro_utf8=> show client_encoding;
client_encoding
-----------------
LATIN9
(1 ligne)
ppro_utf8=> show server_encoding;
server_encoding
-----------------
UTF8
(1 ligne)
I suspect something to do with locales on Debian? The good server (primary) is
an OVH hosted machine, which runs a debian version that they customize, while
the bad one (backup) was built using stock debian net-install. I found a
difference in the LANGUAGE environnement variable (with that strange fr_FR:fr),
other than that all configuration files are identical on both machines.
cat /etc/default/locale
#Primary
LANG=fr_FR@euro
LANGUAGE=fr_FR:fr
#Backup
LANG=fr_FR@euro
--
Ron Savage
savage.net.au
