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:30:22
Message-ID: E1Cya7y-0002nQ-00@www.strato-webmail.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I still recive the same error-message

thx,
Bernd

--- Ursprüngliche Nachricht ---
Datum: 08.02.2005 19:13
Von: javier wilson <javier(dot)wilson(at)gmail(dot)com>
An: "bernd(at)kalwar(dot)net" <bernd(at)kalwar(dot)net>
Betreff: Re: [GENERAL] Cannot connect to Database

> have you tried connecting to it with other tool, like "psql -h
> localhost -U postgresql test" ?
> in my opinion the message is clear, something must be wrong with
pg_hba.conf
> have reloaded postgresql after updating this file?
>
> javier
>
> On Tue, 08 Feb 2005 19:01:28 +0100, bernd(at)kalwar(dot)net <bernd(at)kalwar(dot)net>
wrote:
> > > 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
> > >
> >
> > ---------------------------(end of
broadcast)---------------------------
> > TIP 5: Have you checked our extensive FAQ?
> >
> > http://www.postgresql.org/docs/faq
> >
>

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2005-02-08 18:31:03 Re: Cannot connect to Database
Previous Message bernd 2005-02-08 18:22:03 Re: Cannot connect to Database