Cannot connect to postgreSQL via JDBC

Question

Been at this for days i cant make a connection to my postgreSQL database on my local machine, running mac os ML.

nmap of my machine shows that postgres is running on 5432 and i can connect locally via pgadmin and psql.

pg_hba.conf file for postgres    
local   all             all                                     trust    
host    all             all             127.0.0.1/32           trust    
host    all             all             192.168.0.2/16            trust

listen address is set to *

I get the follwing exception when i try to connect with JDBC

org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.

Thought its also worth adding that i CANT connect via pg admin from a machine on my LAN. I also read somewhere that all JDBC connections go through tcp/ip not via the local host loopback, the thing is i cant get postgres to listen — Luke De Feo
– Luke De Feo, Commented Jan 20, 2013 at 9:39
Nevermind feel so stupid found the problem The listen address is commented out by default in postgres config and i didnt notice due to the line wrapping. Godammit. Sorry for wasting your time — Luke De Feo
– Luke De Feo, Commented Jan 20, 2013 at 9:46

Chris Travers · Accepted Answer · 2013-04-22 00:59:44Z

1

In troubleshooting these sorts of problems check the following in order:

Can you connect to PostgreSQL from another machine on the LAN? If not, it may not be listening on the address?
Can you connect locally? Is it even running?

Now in the case where the second succeeds and the first fails, here are things to check in order:

listen_address in postgresql.conf
firewall rules
Anything in between that might interfere with the network connections.

answered Apr 22, 2013 at 0:59

Chris Travers

26.6k6 gold badges70 silver badges191 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Cannot connect to postgreSQL via JDBC

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related