Re: Installing Postgresql on Debian (-E parameter question)

From: Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
To: various(at)protocol(dot)gr
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Installing Postgresql on Debian (-E parameter question)
Date: 2009-07-09 19:38:50
Message-ID: 6A07E0FF-95BD-4DD8-B3E1-38CED38FEA21@hi-media.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

Le 9 juil. 09 à 20:57, Panos Katergiathis a écrit :
> a) Is it still essential to pass the -E proper parameter at the
> stage of
> 'initdb' in order to support various encodings fully?

Yes.

> b) If so, how does one pass this parameter when installing from a
> standard *.deb package (or *.rpm, for that matter)?

In debian case a default encoding and locale is defined at install
time from your environment. You can then rebuild a cluster with debian
wrapper tools:
pg_lsclusters
pg_dropcluster 8.4 main
pg_createcluster -e 8.4 main

See man pages on your system, or even online:
http://pwet.fr/man/linux/commandes/pg_lsclusters
http://pwet.fr/man/linux/administration_systeme/pg_dropcluster
http://pwet.fr/man/linux/administration_systeme/pg_createcluster

> c) If so (in reference to question (a)), is there any tutorial around
> for installing Postgresql on Debian, that includes instructions for
> the
> -E parameter?

See above, let the installer do its job then if you find it's not what
you wanted, you should fix your environment (which drives installer
decisions) or drop then create again the cluster.

> d) Is there anything else that i should be aware of, relating to
> proper
> character-set support in recent versions of Postgresql?

The cluster's encoding and locale have to be compatible with what you
want your database to have, in 8.4. In 8.3, only the encoding is to
consider as you couldn't change locale per database, it was per cluster.

Regards,
--
dim

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Rafael Domiciano 2009-07-09 22:18:55 Setting Shared-Buffers
Previous Message Panos Katergiathis 2009-07-09 18:57:40 Installing Postgresql on Debian (-E parameter question)