PostgreSQL refusing connection

Question

I hava a PostgreSQL database on my PC. The Postgres server is running on port 5432. When I go on another PC and type in telnet server.ip 5432, I manage to connect. However when I try to connect using Java:

connection = DriverManager.getConnection("Jdbc:postgresql:mydb://server.ip:5432/", "user", "pass");

I get the following error: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections. Can someone tell me what the problem might be?

UPDATE:

I changed the connection string to:

connection = DriverManager.getConnection("jdbc:postgresql://server.ip:5432/mydb", "user", "pass");

and now I am getting the error FATAL: no pg_hba.conf entry for host "client.ip", user "user", database "mydb", SSL off

A.H. · Accepted Answer · 2013-04-28 18:06:29Z

2

Your JDBC connection string is wrong. The documentation says these are the allowed formats:

jdbc:postgresql:database
jdbc:postgresql://host/database
jdbc:postgresql://host:port/database

but not - as in your case:

Jdbc:postgresql:databse://host:port/

(also note the capital letter J in your string which is also not allowed)

answered Apr 28, 2013 at 18:06

A.H.

66.8k16 gold badges97 silver badges132 bronze badges

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

Comments

A.H. · Accepted Answer · 2013-04-28 18:09:33Z

1

You need to config auth file /etc/postgresql/x.x/main/pg_hba.conf

Add these lines:

# TYPE DATABASE  USER  ADDRESS                   METHOD
host   all       all   my.pc.ip/Prefix-netmask   md5

After that restart the postgresql server:

# /etc/init.d/postgresql restart

edited Apr 28, 2013 at 18:09

A.H.

66.8k16 gold badges97 silver badges132 bronze badges

answered Apr 28, 2013 at 18:03

Malik Benmekki

1084 bronze badges

2 Comments

A.H. Over a year ago

Hmmm. The question says, my.pc.ip is the IP of the server. But the server's config file must contain the IP of the remote client.

duncanportelli Over a year ago

I added the remote client IP in pg_hba.conf and it worked. Thanks @A.H.

Collectives™ on Stack Overflow

PostgreSQL refusing connection

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