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 4: Don't 'kill -9' the postmaster
