Search Postgresql Archives

Re: Cannot connect to Database

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I still recive the same error-message

thx,
Bernd

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


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
      message can get through to the mailing list cleanly


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux