Re: Cannot connect to Database - Mailing list pgsql-general

From bernd@kalwar.net
Subject Re: Cannot connect to Database
Date
Msg-id E1Cya7y-0002nQ-00@www.strato-webmail.de
Whole thread Raw
In response to Cannot connect to Database  (bernd@kalwar.net)
List pgsql-general
I still recive the same error-message

thx,
Bernd

 --- Ursprüngliche Nachricht ---
Datum: 08.02.2005 19:13
Von: javier wilson <javier.wilson@gmail.com>
An: "bernd@kalwar.net" <bernd@kalwar.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@kalwar.net <bernd@kalwar.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@gmail.com>
> > An: "bernd@kalwar.net" <bernd@kalwar.net>
> > Betreff: Re: [GENERAL] Cannot connect to Database
> >
> > > On Tue, 08 Feb 2005 18:46:00 +0100, bernd@kalwar.net
<bernd@kalwar.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@gmail.com
> > > LlamaLand                       http://netllama.linux-sxs.org
> > >
> >
> > ---------------------------(end of
broadcast)---------------------------
> > TIP 5: Have you checked our extensive FAQ?
> >
> >                http://www.postgresql.org/docs/faq
> >
>


pgsql-general by date:

Previous
From: bernd@kalwar.net
Date:
Subject: Re: Cannot connect to Database
Next
From: Scott Marlowe
Date:
Subject: Re: Cannot connect to Database