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 7: don't forget to increase your free space map settings
