谁能解答新用户SCI登陆 数据库名BMC --port 5446

小帅哥飞飞

谁能解答新用户SCI登陆 数据库名BMC --port 5446出现的错误?

1.先创建一个新用户SCI

bash-2.05b$ createuser -P -p5446 SCI
Enter password for user "SCI":
Enter it again:
Shall the new user be allowed to create databases? (y/n) n
Shall the new user be allowed to create more new users? (y/n) n
CREATE USER

2.PostgreSQL已经启动,以postgres身份登陆

bash-2.05b$ psql BMC -p 5446
Welcome to psql 7.3.10-RH, 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

psql: relocation error: psql: undefined symbol: PQgetssl


bash-2.05b$ psql -p 5446 -U SCI BMC
Welcome to psql 7.3.10-RH, 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

psql: relocation error: psql: undefined symbol: PQgetssl

从参考的文献中得知：
http://www.pgsqldb.org/pgsqldoc-8.1c/tutorial-accessdb.html

预想出现的应该是:
mydb=>
最后一行也可能是
mydb=#
_________________________________

小帅哥飞飞

因为登陆用的是ssh,所以如果是用SCI这个新建的用户名运行psql去访问BMC就会出这个错.

但是如果用的是命令:su postgres -c"/usr/local/pgsql_15/bin/psql BMC --port=5446"就可以,因为/etc/passwd下已经有postgres了
下一步我想用SCI这个新建的数据库用户名去登陆phppgAdmin, 本来User ID 是dbadmin,

Reece Hart <[EMAIL PROTECTED]> writes:
> On Thu, 2004-01-22 at 16:13, Phil Campaigne wrote:
>> psql: relocation error: psql: undefined symbol: PQgetssl

> I vaguely remember seeing a similar message when I inadvertently
> mismatched versions of psql and libpq. I think that the problem was psql
> resolving to the wrong libpq, but this is an old memory.

This undoubtedly indicates that you have an SSL-enabled psql that is
trying to use a non-SSL-enabled libpq.so.  So (a) you were not
consistent about your configure options between 7.3.2 and 7.3.4
--- you might want to look and see if there were any other unintentional
changes; and (b) your ldconfig or LD_LIBRARY_PATH setup is finding the
"wrong" version of libpq.so.  Reece's suggestion to use ldd will help
you figure out what's up with (b).