Re: [GENERAL] WIN1251 localization

2013-06-21 Thread Yuriy Rusinov
Hello ! Sorry for delay. Yes there are two version of postgresql 8.4 and 9.1 and suddenly all begin to work properly. pg_lsclusters output is Version Cluster Port Status OwnerData directory Log file 8.4 main 5432 down postgres /var/lib/postgresql/8.4/main /var/log/postgresql/post

Re: [GENERAL] WIN1251 localization

2013-06-17 Thread Petko Godev
On Sat, Jun 15, 2013 at 11:04:28PM +0400, Yuriy Rusinov wrote: > Postgres 9.1 > > utf-8 Is this the system locale or the pgcluster encoding? What is the output of the pg_lsclusters? Consider the utf8 convertion of those initial scripts if this is not an option, then just create new cluster with

Re: [GENERAL] WIN1251 localization

2013-06-16 Thread Petko Godev
On Sat, Jun 15, 2013 at 11:04:28PM +0400, Yuriy Rusinov wrote: > Postgres 9.1 > > utf-8 Is this the system locale or the pgcluster encoding? What is the output of the pg_lsclusters? Consider the utf8 convertion of those initial scripts if this is not an option, then just create new cluster with

Re: [GENERAL] WIN1251 localization

2013-06-15 Thread Adrian Klaver
On 06/15/2013 12:04 PM, Yuriy Rusinov wrote: Postgres 9.1 utf-8 How was Postgres installed? Is there more than one instance of Postgres on the machine? The conversion should be possible, so it would seem either the conversion library is not there or it cannot be found by the server.

Re: [GENERAL] WIN1251 localization

2013-06-15 Thread Yuriy Rusinov
Postgres 9.1 utf-8 On Sat, Jun 15, 2013 at 5:53 PM, Adrian Klaver wrote: > On 06/15/2013 02:16 AM, Yuriy Rusinov wrote: > >> >> Hello, All ! >> >> I am developing database. Initial scripts contains information in >> win1251 encoding. Now I have received problem >> >> c_db1=# \encoding WIN1251 >

Re: [GENERAL] WIN1251 localization

2013-06-15 Thread Adrian Klaver
On 06/15/2013 02:16 AM, Yuriy Rusinov wrote: Hello, All ! I am developing database. Initial scripts contains information in win1251 encoding. Now I have received problem c_db1=# \encoding WIN1251 WIN1251: invalid encoding name or conversion procedure not found c_db1=# locale in system was def

[GENERAL] WIN1251 localization

2013-06-15 Thread Yuriy Rusinov
Hello, All ! I am developing database. Initial scripts contains information in win1251 encoding. Now I have received problem c_db1=# \encoding WIN1251 WIN1251: invalid encoding name or conversion procedure not found c_db1=# locale in system was defined by this $ sudo localedef -c -i ru_RU -f CP1