Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 653221337B92 for ; Thu, 10 Feb 2011 13:02:54 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 47974-04 for ; Thu, 10 Feb 2011 17:02:47 +0000 (UTC) X-Greylist: delayed 00:05:45.748162 by SQLgrey-1.7.6 Received: from extern.innogames.de (extern.innogames.de [80.252.99.240]) by mail.postgresql.org (Postfix) with ESMTP id 34D031337B82 for ; Thu, 10 Feb 2011 13:02:47 -0400 (AST) Received: from [172.16.5.29] (unknown [212.48.107.10]) by extern.innogames.de (Postfix) with ESMTPA id 92FD728F195 for ; Thu, 10 Feb 2011 17:56:59 +0100 (CET) Subject: LC_COLLATE and pg_upgrade From: Bernhard Schrader To: pgsql-admin@postgresql.org Content-Type: text/plain; charset="UTF-8" Organization: Innogames GmbH Date: Thu, 10 Feb 2011 17:56:58 +0100 Message-ID: <1297357018.2340.10.camel@schrader-laptop> Mime-Version: 1.0 X-Mailer: Evolution 2.28.3 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201102/69 X-Sequence-Number: 36708 Hi all, I just tried to pg_upgrade a PostgreSQL-8.4 to 9.0. pg_upgrade stopped with this message: "old and new cluster lc_collate values do not match" So i checked the LC_COLLATE on 8.4 and 9.0: 8.4: postgres=# show lc_collate; lc_collate ------------ en_US.utf8 (1 row) 9.0: postgres=# show lc_collate; lc_collate ------------ en_US.UTF-8 (1 row) Well... I think you see my problem, i don't even know if it is really a problem... Is it possible just to change the lc_collate on the 8.4 machine? Obviously its the same encoding, or am i wrong? My second Question, but not that urgent is about two databases which have LC_COLLATE=C, is there a safe way to get it to UTF-8? regards Bernhard