Skip site navigation (1) Skip section navigation (2)

localisation - collation sequencies

From: tövis <tovises(at)freemail(dot)hu>
To: "pgsql novice" <pgsql-novice(at)postgresql(dot)org>
Subject: localisation - collation sequencies
Date: 2005-04-20 22:04:17
Message-ID: 007f01c545f4$e555cf30$3401a8c0@mainxp (view raw or flat)
Thread:
Lists: pgsql-novice
I'm using PostgreSQL 7.4.x installed on Debian Sarge or testing distribution.
I'm realized that I does not set apropriate locale - for me, for now it is hu_HU ISO8859-2.
First of all I generated locale hu_HU and set as default (dpkg-reconfigure locales)
Try reconfigure postgresql - dpkg-reconfigure postgresql - but it is not solve the problem.
After long struggling on the WEB and exploring my home server I found initdb (it is quite hidden - /usr/lib/postgresql/bin/).
Stop postmaster - #/etc/init.d/postgresql stop.
Clean my old and wrong data "cluster" - /var/lib/postgres/data
As user "postgres" rebuild the cluster, with apropriate locale and password for user "postgres".
Restore links to settings in /etc/postgresql - pg_hba.conf, pg_ident.conf, postgresql.conf.
Start postmaster - #/etc/init.d/postgresql start
locale and collate is became well.
This is the right way? - nothing more simple (for my fortune no real database was there, I did not need to rebuild;o).

pgsql-novice by date

Next:From: Leif K-BrooksDate: 2005-04-21 09:33:12
Subject: Performance of multiple queries?
Previous:From: tövisDate: 2005-04-20 21:49:01
Subject: Re: records chaining

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group