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
>