Re: Cannot connect to Database

Did you restart Postgresql after editing your pg_hba.conf file?

On Tue, 2005-02-08 at 12:22, bernd@kalwar.net wrote:
> 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
> >
> >
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org