Did you restart Postgresql after editing your pg_hba.conf file? On Tue, 2005-02-08 at 12:22, bernd@xxxxxxxxxx wrote: > I recvive still the same error-message. > > thx, > Bernd > > --- UrsprÃngliche Nachricht --- > Datum: 08.02.2005 19:14 > Von: "Joshua D. Drake" <jd@xxxxxxxxxxxxxxxxx> > An: bernd@xxxxxxxxxx > Betreff: Re: Cannot connect to Database > > > 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. > > > > 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@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 > > > > > > -- > > 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@xxxxxxxxxxxxxx ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)
