postgresql

Nakuta

那个网站真是不错，多谢斑竹~~~~~

ministerwuxi

我现在可以进入了
用的是 postgres 身份用了su - postgres出现bash-2.05$然后就可以建立数据库了
谢谢上面的朋友
如果我想知道有那些数据库的话用什么命令呢
mysql的有show databases;
postgresql可以批psql mydb
但是如果不知道有那些数据库的时候怎么样来打开数据库呢
有什么命令能浏览一下吗

黄叶

输入\l
就可以了。

damonbi

Oh man. There are lots of such commands you just cannt ask one by one. The key to study is try to be a good problem solver yourself. There are also a bunch of docs for postgresql you may like to check out, not that far at all, in my machine, it is located in /usr/share/doc/postgresql-7.3.2/, so may be yours. Ah, The chinese version can be found in http://laser.zhengmai.com.cn/, as stated in 本版常用网站列表. Sometimes solving problems by yourself can be much more efficient than asking in a bbs and then wait for a couple of days. , at least apply to problem like this. WHEN YOU RUN PSQL, CAN YOU SEE PRINT OUT LIKE THIS:

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

Man, it just tells everything. I am a newbie db designer(started db study 2 weeks ago), should say. But I always ask question carefully because it saves time, both mine and others. Make sure you ask something worthy before you do so.

princeblue

i can create user for postgresql ,and successful ,but when i want to use this user
to enter postgresql ,the error appeared;
just like:
bash-2.05b$psql -U jonny -d test
psql: 致命错误 1:  为用户 "jonny" IDENT 认证失败

what's wrong with it?
thanks!

黄叶

认证出了问题。

uljling

认证出了问题。怎么办?

不过我用postgres可以进,
bash-3.1$ useradd linuxqq
Password:
useradd：PAM 验证失败
bash-3.1$ psql
Welcome to psql 8.1.5, 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=#

cg111

问题1请查阅文挡；
问题2请查阅文挡；
问题3请查阅文挡；
。。
问题X请查阅文挡！！！
cvs文挡中文版
http://www.pgsqldb.org/pgsqldoc-cvs/index.html
在
http://www.pgsqldb.org/
中有各个版本的中文文挡可以查阅，感谢laser和他的小组的工作。
E文文挡可以在
http://www.postgresql.org/
的官方网站找到。