Обсуждение: Problem with encoding conversions

Hi All,
I try to migrate a database from WIN1251 to UTF8 but
I have a problem dumping from WIN1251 to UTF8.

pg_dump -C -E 'UTF8' a > a_utf8.sql
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR:  could not load library
"/usr/local/lib/postgresql/utf8_and_cyrillic.so": dlopen
(/usr/local/lib/postgresql/utf8_and_cyrillic.so) failed:
/usr/local/lib/postgresql/utf8_and_cyrillic.so: Undefined symbol
"check_encoding_conversion_args"
pg_dump: The command was: SET client_encoding='UTF8'


$psql --help
This is psql 8.1.16, the PostgreSQL interactive terminal.

a=#SELECT version();
                                             version
-------------------------------------------------------------------------------------------------
 PostgreSQL 8.1.15 on i386-portbld-freebsd6.4, compiled by GCC cc (GCC)
3.4.6 [FreeBSD] 20060305
(1 row)

a=# \l
           List of databases
       Name        |  Owner  | Encoding
-------------------+---------+----------
 a                 | kaloyan | WIN1251

Could you please suggest what to do. I try to Google for a solution but
nothing appears.

Thanks in advance.

Kaloyan

Sorry for the noise.
The problem is solved with the restart of the postgresql server.

Have a nice day.

Kaloyan Iliev

Kaloyan Iliev wrote:

> Hi All,
> I try to migrate a database from WIN1251 to UTF8 but
> I have a problem dumping from WIN1251 to UTF8.
>
> pg_dump -C -E 'UTF8' a > a_utf8.sql
> pg_dump: SQL command failed
> pg_dump: Error message from server: ERROR:  could not load library
> "/usr/local/lib/postgresql/utf8_and_cyrillic.so": dlopen
> (/usr/local/lib/postgresql/utf8_and_cyrillic.so) failed:
> /usr/local/lib/postgresql/utf8_and_cyrillic.so: Undefined symbol
> "check_encoding_conversion_args"
> pg_dump: The command was: SET client_encoding='UTF8'
>
>
> $psql --help
> This is psql 8.1.16, the PostgreSQL interactive terminal.
>
> a=#SELECT version();
>                                             version
> -------------------------------------------------------------------------------------------------
>
> PostgreSQL 8.1.15 on i386-portbld-freebsd6.4, compiled by GCC cc (GCC)
> 3.4.6 [FreeBSD] 20060305
> (1 row)
>
> a=# \l
>           List of databases
>       Name        |  Owner  | Encoding
> -------------------+---------+----------
> a                 | kaloyan | WIN1251
>
> Could you please suggest what to do. I try to Google for a solution
> but nothing appears.
>
> Thanks in advance.
>
> Kaloyan
>