That was it. i've two hb_conf-Files on my system. Now I can connect without any problems. thx --- Ursprüngliche Nachricht --- Datum: 08.02.2005 20:06 Von: Scott Marlowe <smarlowe@xxxxxxxxxxxxxxxxx> An: bernd@xxxxxxxxxx Betreff: Re: Cannot connect to Database > Is postgresql on the same machine as your applicaiton? > > Are you sure postgresql is starting up in the directory you think it is? > > On Tue, 2005-02-08 at 12:44, bernd@xxxxxxxxxx wrote: > > > Did you restart Postgresql after editing your pg_hba.conf file? > > > > Yes, I did. > > > > thx, > > Bernd > > > > --- Ursprüngliche Nachricht --- > > Datum: 08.02.2005 19:31 > > Von: Scott Marlowe <smarlowe@xxxxxxxxxxxxxxxxx> > > An: bernd@xxxxxxxxxx > > Betreff: 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@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 7: don't forget to increase your free space map settings > ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)
