I've already shutdown my firewall. My OS is Linux (SuSE 9.2 64Bit) My postgre version is 7.4.6 and the port is on listen-mode postgres@amd64:/home/bernd> netstat -an | grep 5432 tcp 0 0 0.0.0.0:5432 0.0.0.0:* LISTEN tcp 0 0 :::5432 :::* LISTEN unix 2 [ ACC ] STREAM HÖRT 15159 /tmp/.s.PGSQL.5432 thx, Bernd --- Ursprüngliche Nachricht --- Datum: 08.02.2005 19:56 Von: Lonni J Friedman <netllama@xxxxxxxxx> An: "bernd@xxxxxxxxxx" <bernd@xxxxxxxxxx> Betreff: Re: Cannot connect to Database > Well, its obviosly not listening on localhost. Are you firewalling > anywhere? Which OS is this? Which version of postgresql? > > If this is Linux, what do you get from running 'netstat -an | grep 5432' ? > > On Tue, 08 Feb 2005 19:44:26 +0100, bernd@xxxxxxxxxx <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 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
