X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id C540F9DCCCA for ; Sun, 26 Mar 2006 01:22:31 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 99239-08 for ; Sun, 26 Mar 2006 01:22:30 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id E321A9DCA47 for ; Sun, 26 Mar 2006 01:22:29 -0400 (AST) Received: from imap.unet.univie.ac.at (imap.unet.univie.ac.at [131.130.221.38]) by svr4.postgresql.org (Postfix) with ESMTP id D0A635AF9E8 for ; Sun, 26 Mar 2006 05:22:29 +0000 (GMT) X-Spam-Flags: <.FIVETEN-SPAMSRC.BLARS-SPAMSENDER.@imap.unet.univie.ac.at>[80.109.13.165:chello080109013165.10.14.univie.teleweb.at] Received: from [192.168.2.100] (chello080109013165.10.14.univie.teleweb.at [80.109.13.165]) by imap.unet.univie.ac.at (8.12.10/8.12.10) with ESMTP id k2Q5M7HK206516; Sun, 26 Mar 2006 07:22:20 +0200 Message-ID: <442624FF.6000604@falter.at> Date: Sun, 26 Mar 2006 07:22:07 +0200 From: Erwin Brandstetter User-Agent: Thunderbird 1.5 (Windows/20051201) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: database locale and system locale Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-DCC-ZID-Univie-Metrics: mx8 4248; Body=0 Fuz1=0 Fuz2=0 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200603/266 X-Sequence-Number: 21023 Hi everyone! I've been reading tons of stuff on locale and postgresql. I am still not in the clear about some details, though: how do system locale and database locale work together (or not)? (In my case, I am speaking of postgresql 8.1 on debian sarge. But general understanding is what I am looking for.) If I am running a database cluster with --encoding= UTF8, are there any troubles to be expected if the system locale remains "C" or somehting like "de_AT.iso885915@euro"? Any troubles with error messages, dumps, hacking the dump, performance? Any trouble at all? Is it enough to have an UTF8 locale installed on the system? postgres@dbneu:~$ locale -a C de_AT.utf8@euro Or does it actually have to be the system locale? postgres@dbneu:~$ locale LC_ALL="de_AT.UTF-8@euro" Do multiple UTF8 system locales have any effect? postgres@dbneu:~$ locale -a C de_AT.utf8@euro en_US.utf8 Does anyone know these details? It would ease my mind. :) Thanx in advance! Regards Erwin Brandstetter