JDBC to PostgreSQL Not working since upgrading Ubuntu

Question

So I had PostgreSQL working in Ubuntu 11.04 using 8.4(?), however, when I upgraded it also upgraded PostgreSQL to 9.1 and now I can't connect using JDBC.

I added the following to my pg_hba.conf

host    all             all             127.0.0.1/32            trust
host    all             all             0.0.0.0/0               trust

and the following to my postgres.conf...

listen_addresses = '*'

but I get the following connecting with SQuirrel

My Local PostgresSQL: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.

Any ideas?

This question is a better fit for superuser.com or serverfault.com or askubuntu.com — Paul Sasik
– Paul Sasik, Commented Oct 17, 2011 at 17:13
Sounds like your server is not started. Can you connect using psql? — user330315
– user330315, Commented Oct 17, 2011 at 17:15

cregox · Accepted Answer · 2014-10-07 22:21:44Z

2

Per this site the default port is 5432, however, per the postgres.conf file that came installed by default the port is set to 5433...

port = 5433

So if someone else has this problem try the new port.

I think it has to do with the install incrementing the port when it sees the existing 8.4

edited Oct 7, 2014 at 22:21

cregox

18.6k16 gold badges90 silver badges120 bronze badges

answered Oct 18, 2011 at 16:08

Jackie

24k43 gold badges178 silver badges340 bronze badges

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

Comments

A.H. · Accepted Answer · 2011-10-17 17:49:13Z

0

Perhaps a IPv4 vs IPv6 issue? Try adding this line

host    all         all         ::1/128               trust

and try connecting to the hostname localhost.

If that's not a solution, please try md5 instead of trust and give the connecting user a password. Just to be sure to rule this out.

answered Oct 17, 2011 at 17:49

A.H.

66.8k16 gold badges97 silver badges132 bronze badges

2 Comments

Jackie Over a year ago

host all all ::1/128 md5 already exists in the file. I tried making it trust, and I also tried making the other one md5 no dice, thanks though.

Jackie Over a year ago

Will post in 6 hours (freaking rule!) but here is the answer FYI Per this site the default port is 5432, however, per the postgres.conf file that came installed by default the port is set to 5433... port = 5433 So if someone else has this problem try the new port.

Collectives™ on Stack Overflow

JDBC to PostgreSQL Not working since upgrading Ubuntu

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related