Re: Cannot connect to Database

From: Lonni J Friedman <netllama(at)gmail(dot)com>
To: "bernd(at)kalwar(dot)net" <bernd(at)kalwar(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Cannot connect to Database
Date: 2005-02-08 17:52:03
Message-ID: 7c1574a90502080952bf6510e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, 08 Feb 2005 18:46:00 +0100, bernd(at)kalwar(dot)net <bernd(at)kalwar(dot)net> wrote:
> Hi,
>
> everytime I try to connect to my Database with a Java-Applikation, I
> recieve only the following Exception:
>
> org.postgresql.util.PSQLException: A connection error has occurred:
> org.postgresql.util.PSQLException: FATAL: kein pg_hba.conf-Eintrag für
> Host »127.0.0.1«, Benutzer »postgres«, Datenbank »test«, SSL aus
>
> I get the same error-message with other applications, e.g. pgaccess, too.
>
> My pg_hba.conf looks like:
>
> # TYPE DATABASE USER IP-ADDRESS IP-MASK
> METHOD
>
> host all all 127.0.0.1 255.255.255.255 trust
>
> The database and the applications are on the same host.
>
> What could be the problem.

Do you have TCP/IP activated in postgresql.conf ? Are you trying to
connect via localhost (127.0.0.1) or some other route?

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
L. Friedman netllama(at)gmail(dot)com
LlamaLand http://netllama.linux-sxs.org

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jonel Rienton 2005-02-08 17:55:31 Re:
Previous Message mike 2005-02-08 17:47:22 Re: Confused by to_char