PostgresSQl高手请进

jin.liu

我现在在用Pgaccess可是它为什么一直说连接不上呢？？？
什么connection refused怎么办？？？
谢谢！！

黄叶

说说你的PostgreSQL 软件的版本。
你先切换到root用户
然后再切换到postgres用户。输入
psql template1
应该就可以连上。
注意看看postgreSQL用户认证方法。
可修改相关的用户认证文件。

jin.liu

大哥，请继续帮忙：
psql: FATAL:  Missing or erroneous pg_hba.conf file, see postmaster log for details
怎么办啊？？？
谢谢！！

kenny

First, you should make sure that your postgresql server is running:

#ps -A | grep postmaster

And then, you should go to /var/lib/pgsql/data, there should be a postgresql.conf file and a pg_hba.conf file.

In postgresql.conf file, change the tcpip to true. And restart postgresql by "service postgresql restart", then you can connect to the server by tcpip.

In the pg_hba.conf file, you can decide how to authenticate use.