Postgres Pro
Downloads
Home   >   mailing lists

Thread: Unable to connect postgreSQL 8.4 with java application.

Unable to connect postgreSQL 8.4 with java application.

From
Neha Mehta
Date:

  Hi,

 

I am a newbie to postgreSQL. I am trying to connect my java application(using jdbc) with postgreSQL 8.4 , but I am getting the following error :

 

 

FATAL: no pg_hba.conf entry for host "172.17.88.52", user "postgres", database "ofbiz-test", SSL off

 

I tried adding the host name in pg_hba.conf file as :

 

host      all       all   172.17.88.52  255.255.255.255  trust

 

but when I restart the server, I get an error…

 

Could you please help to to find out the missing step.

Also, if there are any more instructions to be followed…

 

Is it necessary to use postgreSQL with SSL if my java application uses SSL??

 

 

 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Thanks & Regards,

Neha Mehta

 

 

 

 


This Email may contain confidential or privileged information for the intended recipient (s) If you are not the intended recipient, please do not use or disseminate the information, notify the sender and delete it from your system.

______________________________________________________________________
Attachment

Re: Unable to connect postgreSQL 8.4 with java application.

From
dmp
Date:
>  Hi,
>
> I am a newbie to postgreSQL. I am trying to connect my java
> application(using jdbc) with postgreSQL 8.4 , but I am getting the
> following error :
>
> FATAL: no pg_hba.conf entry for host "172.17.88.52", user "postgres",
> database "ofbiz-test", SSL off
>
> I tried adding the host name in pg_hba.conf file as :
>
> host all all 172.17.88.52 255.255.255.255 trust
>
> but when I restart the server, I get an error…


Looks like the address must be CIDR-Address, did you try:

host all all 172.17.88.52/32 trust

> Is it necessary to use postgreSQL with SSL if my java application uses
> SSL??

Someone else here should be able to answer this.

danap