Re: how to make collation work

This was help me, on Debian Sarge.
PostgreSQL problems with collation sequence!
#dpkg-reconfigure locales - generate - "hu_HU" and NLS hu_UTF8
#reboot
#/etc/init.d/postgresql stop
#su postgres -> postgres(at)srv02:

empty directory /var/lib/postgres/data

/usr/lib/postgresql/bin/initdb -U
postgres --locale=hu_HU --lc-collate=hu_HU -E LATIN2 \
-D /var/lib/postgres/data -W --pwprompt
... set same password for "postgres" root

cd /var/lib/postgres/data
rm pg_hba.conf
rm pg_ident.conf
rm postgresql.conf

ln -s /etc/postgresql/pg_hba.conf pg_hba.conf
ln -s /etc/postgresql/pg_ident.conf pg_ident.conf
ln -s /etc/postgresql/postgresql.conf postgresql.conf

recreate users and databases - pg_dump?

----- Original Message -----
From: "Havasvölgyi Ottó" <h(dot)otto(at)freemail(dot)hu>
To: <pgsql-novice(at)postgresql(dot)org>
Sent: Sunday, May 01, 2005 8:33 PM
Subject: [NOVICE] how to make collation work

> Hi all,
>
> I am a beginner in Linux and Postgres too, so take this into
> consideration.
> I have installed Fedora Core 3, and PostgreSQL 8.0.2 from source on it.
> All right so far. Now I would like to have a Hungarian collation in my
> tables. This is what I have tried so far:
> I checked what Hungarian locales my Linux supports. These are: hu_HU,
> hu_HU.iso88592, hu_HU.utf8, and hungarian. So far I have tried the first
> and the second with initdb, set the --locale, --lc-collate and --lc-ctype
> to that locale. But after filling a table with Hunagrian characters, and
> selecting it all with order by didn't give the result I expected. The
> encoding of the database and the client was both LATIN2. Neither worked
> the upper() and lower() functions correct with Hungarian characters.
>
> What did I do wrong? Please help.
>
> Thanks,
> Otto
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>