2

I have a PostgreSQL 8.4 on Windows 7 machine, and my issue is that I have only the win1251 locale.

So when I create a database, I choose the UTF8 encoding and can select only lc_collate = Russian_Russia.Win1251. And when I get any errors when I use JDBC I get unreadable logs.

How can I set a locale like en_US.UTF8 or ru_RU.UTF8?

2

PostgreSQL 8.4 supports only one locales that is selected in installation time. You need to rerun initdb statement with different locales (but only one can be used) or you can migrate to 9.x version, that supports more locales.

  • I tried reinstall PostgreSQL 8.4 but not see any locale selection in instalation. For select locale i can not use one click installer? – Kliver Max Sep 10 '13 at 5:44
  • Long time I didn't use a 8.4, but I remember, so there was a some possibilities - maybe your system missing some locales (postgres depends on system resources), maybe you use a some different installator. You can use a initdb command manually without reinstallation, but it needs some deeper knowledge stackoverflow.com/questions/5881845/… – Pavel Stehule Sep 10 '13 at 11:00

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.