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
--
Salutations, Vincent Veyron
http://marica.fr/
Gestion des contentieux, des dossiers de sinistres assurance et des contrats
pour le service juridique
