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 <[EMAIL PROTECTED]> wrote: > "Iuri Sampaio" <[EMAIL PROTECTED]> 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 >
