PostgreSQL

PostgreSQL: Not Listening

http://stackoverflow.com/questions/12286886/postgresql-server-doesnt-listen

ERROR 1

could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host “xxx.xxx.xxx.xxx” and accepting TCP/IP connections on port 5432?

listen_addresses = '*' 
in /etc/postgresql/9.1/main/postgresql.conf.

ERROR 2

FATAL: no pg_hba.conf entry for host “xxx.xx.xxx.xxx”, user “postgres”, database “postgres”, SSL on FATAL

Edit pg_hba.conf

Add the following line:

 host                       all               all             0.0.0.0/0                  md5

This is very unsafe but for testing purposes it will allow any ip to connect to the database.

Leave a Reply

Your email address will not be published. Required fields are marked *