Re: Cannot connect to Database

From: bernd(at)kalwar(dot)net
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Cannot connect to Database
Date: 2005-02-08 18:01:28
Message-ID: E1CyZg0-0002aZ-00@www.strato-webmail.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

I start the Server with the -i option, so TCP/IP is activated, isn't it?
I want to connect by localhost to my database.

thx,

Bernd

--- Ursprüngliche Nachricht ---
Datum: 08.02.2005 18:52
Von: Lonni J Friedman <netllama(at)gmail(dot)com>
An: "bernd(at)kalwar(dot)net" <bernd(at)kalwar(dot)net>
Betreff: Re: [GENERAL] Cannot connect to Database

> 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
>

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2005-02-08 18:14:41 Re: Cannot connect to Database
Previous Message Jonel Rienton 2005-02-08 17:55:31 Re: