在cmd窗口输入
C:/>runas /user:ibm cmd
输入 ibm 的密码:
试图将 cmd 作为用户 "IBMLT/ibm" 启动...
然后在新开的窗口中
C:/pgsql/lib>../bin/pg_ctl start -D d:/pgdata
启动 postmaster
C:/pgsql/lib>LOG: database system was shut down at 2006-02-26 21:42:29 中国标准
时间
LOG: checkpoint record is at 0/2056A888
LOG: redo record is at 0/2056A888; undo record is at 0/0; shutdown TRUE
LOG: next transaction ID: 422077; next OID: 16987
LOG: next MultiXactId: 1; next MultiXactOffset: 0
LOG: database system is ready
LOG: transaction ID wrap limit is 2147484146, limited by database "postgres"
接着在原来的窗口中
C:/pgsql/lib>../bin/psql -U ibm -d postgres
Welcome to psql 8.1.2, the PostgreSQL interactive terminal.
Type: /copyright for distribution terms
/h for help with SQL commands
/? for help with psql commands
/g or terminate with semicolon to execute query
/q to quit
postgres=#
postgres=# /l
数据库列表
名字 | 所有者 | 编码
-----------+--------+-----------
lt_pgdb | ibm | SQL_ASCII
postgres | ibm | SQL_ASCII
template0 | ibm | SQL_ASCII
template1 | ibm | SQL_ASCII
(4 行)
疑问:为什么在C:/pgsql/bin>psql -U ibm -d postgres报告没有找到libpq.dll,因此这个应用程序未能启动
我是从no_install版本安装的