Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 68CBF6329BD for ; Wed, 3 Feb 2010 05:02:13 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 64103-06 for ; Wed, 3 Feb 2010 09:02:02 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from smadev.internal.net (host3.dynacom.ondsl.gr [62.103.35.211]) by mail.postgresql.org (Postfix) with ESMTP id 5C40063291B for ; Wed, 3 Feb 2010 05:02:01 -0400 (AST) Received: from smadev.internal.net (localhost [127.0.0.1]) by smadev.internal.net (8.14.2/8.14.2) with ESMTP id o1391x3r023273; Wed, 3 Feb 2010 11:01:59 +0200 (EET) (envelope-from achill@matrix.gatewaynet.com) Received: from localhost (localhost [[UNIX: localhost]]) by smadev.internal.net (8.14.2/8.14.2/Submit) id o1391sat023272; Wed, 3 Feb 2010 11:01:54 +0200 (EET) (envelope-from achill@matrix.gatewaynet.com) From: Achilleas Mantzios Organization: Dynacom Tankers Mgmt To: pgsql-admin@postgresql.org Subject: Re: Issues with LC_COLLATE, across 8.3/8.4 on various platforms Date: Wed, 3 Feb 2010 11:01:52 +0200 User-Agent: KMail/1.9.7 Cc: Tom Lane References: <201002021426.44936.achill@matrix.gatewaynet.com> <201002021728.39492.achill@matrix.gatewaynet.com> <5737.1265125025@sss.pgh.pa.us> In-Reply-To: <5737.1265125025@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <201002031101.53452.achill@matrix.gatewaynet.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5 tests=BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201002/36 X-Sequence-Number: 33639 =CE=A3=CF=84=CE=B9=CF=82 Tuesday 02 February 2010 17:37:05 =CE=BF/=CE=B7 To= m Lane =CE=AD=CE=B3=CF=81=CE=B1=CF=88=CE=B5: > Achilleas Mantzios writes: > > What is the shortest way to change the default locale on a production i= nstallation running PostgreSQL-8.3.9? > > Is there anything less painful than dump, initdb,restore? >=20 > No :-( >=20 Thanx Tom, taking into account that the large and most important DB in our installatio= n (over 100Gb as SQL dump) lives in a tablespace of its own, is there a way to "cheat" postgresql after initdb in order to see this tabl= espace and the database in it, avoiding the whole cycle? i think this is not a good idea, i just thought i could ask, just to make s= ure. > regards, tom lane >=20 =2D-=20 Achilleas Mantzios