Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 646876323AE for ; Sun, 30 May 2010 14:03:41 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 17901-07 for ; Sun, 30 May 2010 17:03:34 +0000 (UTC) X-Greylist: delayed 00:27:49.170196 by SQLgrey-1.7.6 Received: from smtprelay-h12.telenor.se (smtprelay-h12.telenor.se [62.127.194.5]) by mail.postgresql.org (Postfix) with ESMTP id 1BEB8632398 for ; Sun, 30 May 2010 14:03:34 -0300 (ADT) Received: from ipb1.telenor.se (ipb1.telenor.se [195.54.127.164]) by smtprelay-h12.telenor.se (Postfix) with ESMTP id 75AEFC75A for ; Sun, 30 May 2010 18:35:42 +0200 (CEST) X-SENDER-IP: [82.182.133.12] X-IronPort-Anti-Spam-Filtered: true X-IronPort-Anti-Spam-Result: AkwCAEYxAkxStoUM/2dsb2JhbAAHkijLM4UWBA X-IronPort-AV: E=Sophos;i="4.53,328,1272837600"; d="scan'208";a="85728981" Received: from 1-1-2-48a.rny.sth.bostream.se (HELO [192.168.0.199]) ([82.182.133.12]) by ipb1.telenor.se with ESMTP; 30 May 2010 18:35:42 +0200 Message-ID: <4C0293DB.4090709@tada.se> Date: Sun, 30 May 2010 18:35:39 +0200 From: Thomas Hallgren User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.1.9) Gecko/20100430 Fedora/3.0.4-2.fc12 Lightning/1.0b1 Thunderbird/3.0.4 MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: LATIN1 on windows Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.701 tagged_above=-10 required=5 tests=BAYES_40=-0.001, RCVD_IN_DNSWL_LOW=-0.7 X-Spam-Level: X-Archive-Number: 201005/293 X-Sequence-Number: 34766 Hi, I'm writing an instruction on how to install a PostgreSQL service on windows. I want to keep it as simple as possible and would therefor very much like to rely on the pre-packaged installer. For various reasons the install has to be Swedish LATIN1 and I have concluded that this can be achieved by using locale Swedish_Sweden.28591 (or sv_SE.28591). Unless I'm missing something, the windows installer doesn't allow that to be specified. So what is the simplest way to do this? I've tried this: - Install using the windows installer. - Stop the service - Wipe the data folder - Do an initdb --locale=sv_SE.28591 -U postgres - Start the service again Is there an easier way? Is there an easy way to make a custom installer? Kind Regards, Thomas Hallgren