我正在尝试连接我的PostgreSQL数据库,它安装在AWS EC2实例上。
我已经在本地的Ubuntu机器上安装了pgadmin3,并尝试连接我的PostgreSQL,但是出现了错误:
reports could not connect to server: Connection refused Is the server running on host "myip" and accepting TCP/IP connections on port 5432?
在AWS上,我已经开放了5432端口。
我编辑了我的postgresql.conf文件,并添加了以下内容:
listen_addresses = '*'
我在pg_hba.conf文件中添加了以下内容:
host all all 192.168.1.0/24 md5
但现在我遇到了这个错误:
FATAL: no pg_hba.conf entry for host "myip", user "postgres", database "postgres", SSL on FATAL: no pg_hba.conf entry for host "myip", user "postgres", database "postgres", SSL off getting this error