Hi Tom,
I'm releaved now. the problem is solved
You're right. the problem was locales not installed.
I just ran "dpkg-reconfigure locales" and install the repsectives.
btw, I'm turned into a pgsql fan.
i just posted a thread at pgsql-sql
http://archives.postgresql.org/pgsql-sql/2007-12/index.php
thanks a lot,
iuri
On Dec 19, 2007 5:23 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> "Iuri Sampaio" <iuri.sampaio@gmail.com> writes:
> > I don;t understand how it's related with postgresql installation. I
> never
> > had this problem before.
> > My locale is set:
>
> > debian:~# locale -a
> > C
> > en_US.utf8
> > POSIX
>
> Well, your original report was about this:
>
> FATAL: invalid value for parameter "lc_messages": "en_CA.UTF-8"
>
> which evidently is not a locale that your system has got. The
> locale -a printout suggests that if it is there, it'd be named
> "en_CA.utf8", and it's hard to tell whether your platform would
> be forgiving of the spelling difference or not. In any case,
> the question is where Postgres got that setting from. AFAIK
> the only likely explanation is that LANG was set that way when
> you ran initdb.
>
> You could try modifying lc_messages in postgresql.conf, but it
> might be safer to wipe the database directory and re-initdb
> with a corrected LANG setting.
>
> regards, tom lane
>