Re: Connection problems - local IP address refused! - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Connection problems - local IP address refused!
Date
Msg-id 52F252C7.7010601@gmail.com
Whole thread Raw
In response to Re: Connection problems - local IP address refused!  (Edson Richter <edsonrichter@hotmail.com>)
Responses Re: Connection problems - local IP address refused!  (Edson Richter <edsonrichter@hotmail.com>)
List pgsql-general
On 02/05/2014 05:43 AM, Edson Richter wrote:
> Em 05/02/2014 11:12, Alban Hertroys escreveu:
>> Are you connecting to the correct host?
>>
>> On 5 February 2014 12:37, Edson Richter <edsonrichter@hotmail.com> wrote:
>>> Without any changes in the configuration files, a **local**
>>> connection to a
>>> local VPN IP address could not be established with the following error:
>>>
>>> The error (JDBC connection using driver version 1002):
>>> 2014-02-05 09:12:21.111 - xxxxx - org.postgresql.util.PSQLException:
>>> ERROR:
>>> could not establish connection
>>>    Detail: FATAL:  no pg_hba.conf entry for host "10.68.73.6", user
>>> "master",
>>> database "master", SSL off
> Sure! On the exatcly same server:
>
> [root@mylocalserver logs]# psql -h 10.68.73.6 -d master -U master
> Senha para usuário master:
> psql (9.2.6)
> Digite "help" para ajuda.

The error message:

  Detail: FATAL:  no pg_hba.conf entry for host "10.68.73.6", user
"master", database "master", SSL off

indicates your JDBC connection is not connecting to a database with the
pg_hba.conf you think it is.

What are the connection parameters for the JDBC connection?

So where is the database running?

What interface is it listening on?

I know it has been asked, but is there another Postgres instance running?


--
Adrian Klaver
adrian.klaver@gmail.com


pgsql-general by date:

Previous
From: rob stone
Date:
Subject: Re: Connection problems - local IP address refused!
Next
From: mephysto
Date:
Subject: Re: Temporary table already exists