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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
