我关注这篇文章((http://nodeexamples.com/2012/09/21/connecting-to-a-postgresql-database-from-node-js-using-the-pg-module/).我已经将我的应用程序部署到heroku,目前正在使用express、node.js,try 连接到我刚刚安装的Heroku中的PostgresSQL数据库.到了文章的最后,我使用了这个命令
node myfile.js
我得到了这个错误
error: no pg_hba.conf entry for host "...", user "...", database "...", ...
我该如何创建一个应用程序,我应该把它放在我的应用程序目录中的什么地方?
下面是整个错误消息.我更改了IP地址、用户和数据库的字符串,但看起来基本上是一样的.
events.js:72
throw er; // Unhandled 'error' event
^
error: no pg_hba.conf entry for host "00.000.000.00", user "username", database "databasename", SSL off
at Connection.parseE (/Users/user/workspace/MyApp/app/node_modules/pg/lib/connection.js:526:11)
at Connection.parseMessage (/Users/user/workspace/MyApp/app/node_modules/pg/lib/connection.js:356:17)
at Socket.<anonymous> (/Users/user/workspace/MyApp/app/node_modules/pg/lib/connection.js:105:22)
at Socket.emit (events.js:95:17)
at Socket.<anonymous> (_stream_readable.js:748:14)
at Socket.emit (events.js:92:17)
at emitReadable_ (_stream_readable.js:410:10)
at emitReadable (_stream_readable.js:406:5)
at readableAddChunk (_stream_readable.js:168:9)
at Socket.Readable.push (_stream_readable.js:130:10)
编辑:我做了更多的研究,发现"pg_hba".conf的文件在我的
/usr/local/var/postgres
我在"pg_hba"中添加了这一行.配置文件
# TYPE DATABASE USER ADDRESS METHOD
host all all trust
也试过
# TYPE DATABASE USER ADDRESS METHOD
host all all 0.0.0.0/0 md5
但它一直说我的主机、用户、数据库等没有条目...