Обсуждение: problem on psql command
Hi, I have just installed postgresql and i have the following messages : postgres@2[postgres]$ createdb testpg /usr/lib/postgresql/bin/readpgenv: line 2: /etc/postgresql/postgresql.env: No such file or directory CREATE DATABASE postgres@2[postgres]$ psql testpg /usr/lib/postgresql/bin/readpgenv: line 2: /etc/postgresql/postgresql.env: No such file or directory Welcome to psql 7.3.4, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help on internal slash commands \g or terminate with semicolon to execute query \q to quit /usr/lib/postgresql/bin/psql: relocation error: /usr/lib/postgresql/bin/psql: undefined symbol: PQgetssl what's the problem ? Could someone help me please. Thanks.
Alexandre Ricciardi <alexandre.ricciardi@free.fr> writes: > I have just installed postgresql and i have the following messages : You seem to have a rather messed-up installation :-( > postgres@2[postgres]$ createdb testpg > /usr/lib/postgresql/bin/readpgenv: line 2: > /etc/postgresql/postgresql.env: No such file or directory I do not know what is causing that warning --- there is no such program as readpgenv in any standard Postgres installation. I think that some Linux distributions' RPMs add on such cruft; I'd suggest filing a bug report with the distribution. But anyway it seems to be just an annoying warning. > /usr/lib/postgresql/bin/psql: relocation error: > /usr/lib/postgresql/bin/psql: undefined symbol: PQgetssl This is happening because a psql program compiled with SSL support is trying to use a libpq.so compiled without SSL support. It would seem that you have two different Postgres installations on your machine and they're conflicting. I'd suggest fully deinstalling the older version. You may also need to do some hacking on ldconfig to get the dynamic loader to find the desired copy of libpq.so. regards, tom lane