Re: encoding problem

"Fouad Fezzi" <fezzi(at)iup(dot)univ-avignon(dot)fr> writes:
> i just upgrading postgres from 7.0 to 7.2 and i have the folowing error in
> configuration process
> what happen ? how to fix this problem ?

> Enter default encoding (SQL_ASCII):
> Now installing the PostgreSQL database files in /var/lib/postgres/data
> su - postgres -c cd /var/lib/postgres; . ./.profile; LANG= initdb --encoding
> SQL_ASCII --pgdata /var/lib/postgres/data
> /usr/lib/postgresql/bin/pg_encoding: relocation error:
> /usr/lib/postgresql/bin/pg_encoding: undefined symbol: pg_char_to_encoding
> initdb: pg_encoding failed

I think that you configured 7.2 with multibyte support but that the old
7.0 installation didn't have it, and for some reason the dynamic linker
is trying to bind the old libpq.so instead of the new one. Check where
you've installed the library, check ldconfig path, etc.

regards, tom lane