Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id 9006613364DE
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu,  4 Nov 2010 18:14:58 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024) with ESMTP id 03605-09 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu,  4 Nov 2010 21:14:51 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from acidenitrix.villemain.org (acidenitrix.villemain.org
	[91.121.90.165])
	by mail.postgresql.org (Postfix) with ESMTP id CD03D1337B80
	for <pgsql-admin@postgresql.org>; Thu,  4 Nov 2010 18:14:50 -0300 (ADT)
Received: from 89-158-241-48.rev.dartybox.com ([89.158.241.48]
	helo=DimIMac.local) by acidenitrix.villemain.org with esmtpsa
	(TLS1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.69)
	(envelope-from <dimitri@2ndQuadrant.fr>)
	id 1PE790-0002WR-6x; Thu, 04 Nov 2010 22:14:50 +0100
Received: by DimIMac.local (Postfix, from userid 501)
	id 52F2F1143310; Thu,  4 Nov 2010 22:14:43 +0100 (CET)
From: Dimitri Fontaine <dimitri@2ndQuadrant.fr>
To: Panos Katergiathis <eyeprotocol@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Installation Questions (FreeBSD / Windows / Postgres 9)
Organization: 2ndQuadrant
References: <AANLkTikWU4CBuOLK8bpBOH17betrvWCHqMGTZuZkfVMk@mail.gmail.com>
User-Mail-Address: dimitri@2ndQuadrant.fr
Date: Thu, 04 Nov 2010 22:14:43 +0100
In-Reply-To: <AANLkTikWU4CBuOLK8bpBOH17betrvWCHqMGTZuZkfVMk@mail.gmail.com>
	(Panos Katergiathis's message of "Wed, 3 Nov 2010 22:26:29 +0200")
Message-ID: <m27hgskczg.fsf@2ndQuadrant.fr>
User-Agent: Gnus/5.110011 (No Gnus v0.11) Emacs/24.0.50 (darwin)
MIME-Version: 1.0
Content-Type: text/plain
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9
X-Spam-Level: 
X-Archive-Number: 201011/34
X-Sequence-Number: 36000

Panos Katergiathis <eyeprotocol@gmail.com> writes:
> Unfortunately, it has been a while since i last compiled and installed
> Postgresql on Linux machines. I remember that selecting the proper
> locale and encoding for the database cluster was a matter to be
> decided at built time. Is it still so for version 9?

No, see CREATE DATABASE documentation here:

  http://www.postgresql.org/docs/9/static/sql-createdatabase.html

CREATE DATABASE name
    [ [ WITH ] [ OWNER [=] user_name ]
           [ TEMPLATE [=] template ]
           [ ENCODING [=] encoding ]
           [ LC_COLLATE [=] lc_collate ]
           [ LC_CTYPE [=] lc_ctype ]
           [ TABLESPACE [=] tablespace ]
           [ CONNECTION LIMIT [=] connlimit ] ]

Regards,
-- 
Dimitri Fontaine
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support