postgresql: not listening


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

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


FATAL: no pg_hba.conf entry for host "", user "postgres", database "postgres", SSL on FATAL

Edit pg_hba.conf

Add the following line:

 host                       all               all                     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 *