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

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

thx,
Bernd

 --- Ursprüngliche Nachricht ---
Datum: 08.02.2005 19:14
Von: "Joshua D. Drake" <jd@commandprompt.com>
An: bernd@kalwar.net
Betreff: Re: [GENERAL] Cannot connect to Database

> 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.
>
>  From the localhost can you:
>
> psql -h 127.0.0.1 -U postgres template1
>
> ?
>
> Sincerely,
>
> Joshua D. Drake
>
>
> >
> > 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
>
>
> --
> Command Prompt, Inc., your source for PostgreSQL replication,
> professional support, programming, managed services, shared
> and dedicated hosting. Home of the Open Source Projects plPHP,
> plPerlNG, pgManage,  and pgPHPtoolkit.
> Contact us now at: +1-503-667-4564 - http://www.commandprompt.com
>
>
>


pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Cannot connect to Database
Next
From: bernd@kalwar.net
Date:
Subject: Re: Cannot connect to Database