Thread: encoding problem

Hi
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


--
_______________________________
Fouad Fezzi
Ingenieur R�seau
IUP Institut Universitaire Professionnalis�
Universite d'Avignon et des Pays de Vaucluse
339 ch. des Meinajaries
tel : (+33/0) 4 90 84 35 50
BP 1228 - 84911 AVIGNON CEDEX 9
fax : (+33/0) 4 90 84 35 01
http://www.iup.univ-avignon.fr
_________________________________

"Fouad Fezzi" <fezzi@iup.univ-avignon.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